narasiman rao

narasiman rao

  • 1.7k
  • 519
  • 705.9k

display the name separated with single cell using sql server

May 15 2017 12:43 PM
  Empid Empname Salary

1 Ram 15000
2 Ramesh 20000
3 Ravi 25000
4 Sam 30000
5 Ganesh 35000


i want to display Empname in single cell separated with space.

i want the output as follows Empname in single cell


Ram Ramesh Ravi Sam Ganesh.

for that how to write the query in sql server. 

Answers (2)