0 - 1 of 1 tags for wm_concat
Equivalent of LISTAGG in teradata

Hello Everyone!
I'm trying to aggregate all the field values of a particular group in one field.
For example, My input table looks like :-

FIELD1 GROUP1

A 1

A 2

B 1

B 2

C 1

C 3

3 null

 

and my output should look like :-

1 A,B,C

By nihal_045, 19 Mar 2014 | Tagged: listagg oracle to teradata migration group_concat wm_concat | 1 comment