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

What is the contrast amongst drop and truncate?

1034

Explain what is public role in sql server?

1135

What is query and its types?

916

What does <> symbol mean?

974

What is a domain constraint give an example?

1049

Explain some stored procedure creating best practices or guidelines?

937

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

Write a program to fetch first 10 records from a file?

1011

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

What is check constraint in sql server?

1002

How efficient you are in oracle and SQL server?

1154

What are distinctive joins find as a part of sql?

953

What is sql service broker?

982

How do I find information about the install locations for the various instances running on a computer?

1085

What is the difference between web edition and business edition?

111