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

How can i Relate Tables in SSIS

690


How to use “drop” keyword in sql server and give an example?

769


How do I start sql server?

604


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

114


What is the definition for sql server 2000?

686






How do I find query history in sql server?

583


What is the return type of executeupdate ()?

623


What is a field name?

615


What do you understand by integration services in sql server?

644


What is meant by indexing?

581


Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

716


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

564


How to view the error log for any specific instance? : sql server database administration

676


Can we take the full database backup in log shipping?

622


What is read committed?

686