How to get list of values in GROUP_BY clause?
If I have data like this in a table
id data
-- ----
1 1
1 2
1 3
2 4
2 5
3 6
3 4
How do I get results like this in a query (on sybase server)?
id data
-- ----
1 1, 2, 3
2 4, 5
3 6, 4
I know that in MySQL there is GROUP_CONCAT and in Sybase I think it's LIST as stated in another answer:
SELECT id, LIST(data||', ')
FROM yourtable
GROUP BY id
In mysql, use
SELECT id, GROUP_CONCAT(data)
FROM yourtable
GROUP BY id
or use your custom separator:
SELECT id, GROUP_CONCAT(data SEPARATOR ', ')
FROM yourtable
GROUP BY id
see GROUP_CONCAT.
For PostgreSQL, using a similar function string_agg.
SELECT id, string_agg(data, ',')
FROM yourtable
GROUP BY id