15.10 - Example: Use ARRAY_AGG - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
Aggregate the job positions into arrays containing the ages of the employees in those jobs.
The example uses the table(s) created earlier.
SELECT pos, ARRAY_AGG(age ORDER BY empId, NEW intarr5()) 
FROM employeeTable 
GROUP BY pos
ORDER BY pos;
Result:
pos         ARRAY_AGG(age ORDER BY empId ASC, NEW intarr5())
------------------------------------------------------------
engineer    (24,34,25,21)
executive   (50,51,52,52,60)
manager     (40,41,45,48)
salesman    (31,32,33,40)