sql - How to get list of values in GROUP_BY clause? -


If I have such data in a table

  id data - --- - 1 1 1 2 1 3 2 4 2 5 3 6 3 4  

How do I get such results in a question (on the Cebes server)?

  id data - - 1 1, 2, 3 2 4, 5 3 6, 4  

I know that in MySQL and in Sybase I think this is in another reply:

  SELECT id, LIST (data | | ',') From yourtable ID by group  

Comments