DB2 Comma Separated Output by Groups
LISTAGG function is new function in DB2 LUW 9.7 see example: create table myTable (id int, category int); insert into myTable values (1, 1); insert into myTable values (2, 2); insert into myTable values (5, 1); insert into myTable values (3, 1); insert into myTable values (4, 2); example: select without any order in grouped … Read more