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
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
List the ways in which dynamic sql can be executed?
What are points to remember while using the fillfactor argument?
How to create a scrollable cursor with the scroll option?
explain extended properties
what data regions are and what are the different data regions?
How do you delete a data source?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to implement service broker?
what are the new features in SSRS?
What are subquery and its properties?
How to Insert multiple rows with a single insert statement?
Differentiate between a primary key and a unique key.
What is index fragmentation in ms sql server?
What are the differences between DDL, DML and DCL in SQL?