How to select top 5 coloumn from a table without using
coloumn name

Answer Posted / satish

select top 5 * from tablename

Is This Answer Correct ?    5 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In what sequence sql statement is processed?

764


Which table keeps information about stored procedures?

717


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

701


What does REVERT do in SQL Server 2005?

711


How to set database to be single_user in ms sql server?

764






What are database states in ms sql server?

833


What are the key configuration files for sql server reporting services ?

150


What are alternate keys?

745


What is an sql server agent?

729


what are user defined datatypes and when you should go for them? : Sql server database administration

752


How to get a list of columns using the "sys.columns" view in ms sql server?

738


What is ms sql server reporting services?

726


List out what other servers you can use with ssrs?

115


Does windows server 2016 come with sql server?

677


What is TDS(Tabular Data Stream) Gateway?

115