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 list all triggers in the database with sys.triggers in ms sql server?

1065

What Is Rdbms?

1145

What will be the maximum number of indexes per table?

955

What are the types of lock supported by ?

1038

How to fetch the next row from a cursor with a "fetch" statement?

1066

What is the simplest way to create a new database in ms sql server?

1002

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

What is the dbcc command and why is it used?

1044

What samples and sample databases are provided by microsoft?

1030

Explain the relational database management system (rdbms)?

1084

How would you choose between a clustered and a non-clustered index?

963

What is nonclustered index with included columns ?

960

Why use stored procedures in sql server?

1005

How do you troubleshoot errors in a SQL Server Agent Job?

1049

can an order by clause be used in a creation of a view?

1167