select list(name) from table

there is a table having two columns no and name
and the data is
1 A
2 B
3 C

write a query that will result a horizontal output
A,B,C

Question Posted / narendra biyani

Answer Posted / narendra biyani

select list(name) from table_name

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to insert multiple rows with one insert statement in ms sql server?

582

What is sqlservr.exe - process - sql server (sqlex?press)?

590

How to use go command in "sqlcmd"?

638

How do you know if sql server is running on your local system?

530

What do we need queues in sql service broker?

520

Explain how to send email from sql database?

554

What is an execution plan? When would you use it?

567

What do mean by xml datatype?

608

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

519

What is sub query and its properties?

533

Where are sql server user names and passwords stored in sql server?

520

What is etl - extraction, transformation, and loading?

516

What is replace and stuff function in sql server?

559

Does a sql server 2005 select statement require a from?

568

Which language rdl files made of?

100