Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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?

890


List the ways in which dynamic sql can be executed?

1002


What are points to remember while using the fillfactor argument?

949


How to create a scrollable cursor with the scroll option?

977


explain extended properties

968


what data regions are and what are the different data regions?

141


How do you delete a data source?

989


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1068


How to implement service broker?

976


what are the new features in SSRS?

134


What are subquery and its properties?

1027


How to Insert multiple rows with a single insert statement?

1035


Differentiate between a primary key and a unique key.

1049


What is index fragmentation in ms sql server?

1059


What are the differences between DDL, DML and DCL in SQL?

1204