I'm trying to aggregate all the field values of a particular group in one field.
For example, My input table looks like :-
I can currently achieve this on Oracle by using the following function
SELECT GROUP1, LISTAGG(FIELD1, ',') WITHIN GROUP (ORDER BY FIELD1) AS GROUPED_FIELD
GROUP BY GROUP1;
Is there a way i can do this in Teradata.
Any help would be appreciated!!
The solution of asked question can be solved by recursive method.I am writing the code.Check in your system.