select top 5 * from tablename

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

Question Posted / satish

Answer Posted / satish

Is This Answer Correct ?

5 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the stuff and how does it differ from the replace function?

1001

What’s the use of custom fields in report?

888

How many full-text indexes can a table have?

926

How to specify the collation for a character data type in ms sql server?

962

Do you know concepts and capabilities of sql server?

1005

How to declare and use cursor variables?

1072

Explain what are partitioned views and distributed partitioned views?

889

What is cdc in sql server?

950

How to receive output values from stored procedures?

1053

Why can there be only one clustered index and not more than one?

928

What is TDS(Tabular Data Stream) Gateway?

121

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1161

How to get the number of affected rows?

947

What is database architecture? : SQL Server Architecture

973

Can you explain about buffer cash and log cache in sql server?

904