set rowcount 5 select * from table

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

Question Posted / sudharshan

Answer Posted / sudharshan

set rowcount 5
select * from table_name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which are the third-party tools used in sql server and why would you use them?

877

What are the different authentication modes in sql server? How can it be changed?

1064

Mention the 3 ways to get a count of the number of records in a table.

961

How do I find the query plan in sql server?

940

What is normalization and denormalization in sql server?

994

What is the use of RDBMS?

986

What were the latest updates to SQL Azure service?

111

What is extended stored procedures?

944

Tell me something about security and sql azure?

114

What are page splits?

987

What is the purpose of a table?

945

What is dbcc updateusage?

1176

what method you can use to reduce the overhead of Reporting Services data sources?

253

What are the differences between lost updates and uncommitted dependencies?

1053

List the different index configurations possible for a table?

923