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

Is mysql the same as sql server?

503


What is the difference between sdf and mdf?

669


If user is owning any SQL Objects, can we drop that user

1601


what's sql server? : Sql server database administration

492


How to change the password of a login name in ms sql server?

555






How do I uninstall sql server 2014?

514


What is it unwise to create wide clustered index keys?

578


What are the High-Availability solutions in SQL Server and differentiate them briefly?

695


What is dbcc?

727


In what version of sql server were synonyms released?

502


How to create nested stored procedure?

537


How to delete all rows with truncate table statement in ms sql server?

482


Which is the latest version of sql server and when it is released?

538


What are different replication agents and what's their purpose? : sql server replication

562


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3368