Sql query to merge multiple row data in one row

Asked Jun 09 '17 at 08:08

Active Jun 09 '17 at 08:09

Viewed 64 times

I have sample data in the format as given below

Now I want data in the format as below:

FirstName                Data 
Kallis                  10, 16, 17     
Sharon                  11, 13, 14, 15
Richard                  12

Please suggest the method or query so that i can get data in the above mentioned format.

edited Jun 09 '17 at 08:09

asked Jun 09 '17 at 08:08

Vineet

3

Which [DBMS](https://en.wikipedia.org/wiki/DBMS) are you using? Postgres? Oracle? – Jun 09 '17 at 08:09
MySQL? Oracle? PostgreSQL? MSSQL? – Evaldas Buinauskas Jun 09 '17 at 08:09
1

Please read http://meta.stackoverflow.com/questions/285551/why-may-i-not-upload-images-of-code-on-so-when-asking-a-question/285557 and the accepted answer – Jun 09 '17 at 08:10
@a_horse_with_no_name Something against MySQL? :P – Tim Biegeleisen Jun 09 '17 at 08:11
1

in mysql you can use group_concat – krishn Patel Jun 09 '17 at 08:11
in sql-server you can use the STUFF function, check this out: https://stackoverflow.com/questions/21760969/multiple-rows-to-one-comma-separated-value – dbajtr Jun 09 '17 at 08:33

0 Answers0