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

How to disable triggers using "disable trigger"?

996

Which Model uses the SET concept

930

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1056

What is transaction server auto commit?

983

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

139

What is the sql case statement used for?

1032

What factors you will consider calculating the storage requirement for that view?

894

Difference between connected and disconnected database in .net with sql server?

1032

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1031

Who is the owner of a schema in ms sql server?

1006

Can sql servers linked to other servers?

971

Explain the relational database management system (rdbms)?

1016

How adventureworkslt tables are related?

877

What method is used by the Command classes to execute SQL statements that return single values?

1003

What do you understand by check constraint in sql server?

884