So I have 5 rows like this
userid, col
--------------
1, a
1, b
2, c
2, d
3, e
How would I do query so it will look like this
userid, combined
1, a b
2, c d
3, e
Combine multiple rows into one space separated string
Viewed 31748
4 Answers
MySQLwith duplicates:select col1, group_concat(col2) from table1 group by col1MySQLwithout duplicates:select col1, group_concat(distinct col2) from table1 group by col1Hivewith duplicates:select col1, collect_list(col2) from table1 group by col1Hivewithout duplicates:select col1, collect_set(col2) from table1 group by col1
Related