Skip to main content
Concatenates input values, including NULL values, into an array.

​
Syntax

ARRAY_AGG(<expression>) [FILTER ([WHERE] <condition>)]

​
Parameters

ParameterDescriptionSupported input type
<expression>Expression of any type to be accumulated into an array.Any
<condition>An optional boolean expression to filter rows used in aggregationBOOL

​
Return Type

ARRAY of the same type as the input data. If there is no input data, ARRAY_AGG returns NULL.

​
Example

For the following example, see the player_information table:
nicknameplayerid
stephen701
burchdenise7
sabrina21NULL
The following code example code selects the columns in the player_information table and returns the values in two arrays, nicknames and playerids: 
SELECT
  ARRAY_AGG(nickname) AS nicknames,
  ARRAY_AGG(playerid) AS playerids
FROM
	price_list;
Returns {'stephen70', 'burchdenise', 'sabrina21'}, {1, 7, NULL} The following code example shows that if a filter is added to the query which rejects all rows, ARRAY_AGG will return NULL: 
SELECT
  ARRAY_AGG(nickname) AS nicknames,
  ARRAY_AGG(playerid) AS playerids
FROM
	price_list
WHERE
  playerid = 42;
Returns NULL, NULL