I want to aggregate as "comma-separated values" within a "group by", like MYSQL group_concat:SELECT dept, GROUP_CONCAT(ename) as employees FROM EMP GROUP BY dept;
or ORACLE listagg:
select dept, listagg(ename, ',') within group (order by ename) as employees ..
select dept, listagg(ename, ',')
What the equivalent SQL syntax in teradata.
You have to use with recursive to implement listagg.