Hello DBExpert,
--input--
state city
AP hyderabad
AP thirupathi
AP vijag
KT bangalore
KT mysure
TN chennai
TN coembattore
--output--
state city
AP hyderabad,thirupathi,vijag
KT bangalore,mysure
TN chennai,coembattore
how can i write the Query to output in sql server