Select Multiple Rows in One Column in SQL

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

DEMO

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

DEMO