ARRAY_AGG(STRUCT(x,y,z)) equivalent in Bigquery legacy SQL

Viewed 6674

I have a standard SQL query of the following structure

SELECT a, ARRAY_AGG(STRUCT(x,y,z))
FROM t
GROUP BY a

How can write the same query in legacy SQL?

2 Answers
Related