Posted by

Posted on

August 16, 2013

Posted under

MS SQL

Comments

Leave a comment

Select multiple rows in one column in SQL

By using FOR XML we can do this

NAME	MOBILE
AAA	1234567890
AAA	3254656796
BBB	3243242343
BBB	2343242326
DDD	344453345
EEE	5243242343
FFF	9223442343

NAME	MOBILE
AAA	1234567890,3254656796
BBB	3243242343,2343242326
DDD	344453345
EEE	5243242343
FFF	9223442343

Leave a comment Cancel reply