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

Answer Posted / narendra biyani

select list(name) from table_name

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of joins?

743


What do you understand by mirroring and mention the advantages of the mirroring?

788


How do I make a resultset scrollable?

710


What is difference between standardization and normalization?

731


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

688






Explain what is sql server english query?

723


Can two tables share a primary key?

709


How to locate and take substrings with charindex() and substring() functions?

696


What is normalization? Explain its different types?

789


What do you understand by coalesce in sql server?

719


What is an indexing technique?

665


How to restore performance issues and how to check?

1704


please differentiate between delete and truncate?

728


How to optimize stored procedure optimization?

669


Give a example to search fr a string in all stored procedure in sql server.

694