Example: Use ARRAY_AGG

Teradata Vantageā„¢ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
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)