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

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

Question Posted / sanjay maurya

Answers were Sorted based on User's Feedback

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

Answer / aashish arora

SELECT top 5 * from information_schema.columns where
table_name = 'varTableName'

Is This Answer Correct ?

2 Yes

0 No

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

Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';

Is This Answer Correct ?

1 Yes

0 No

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

set rowcount 5
select * from table_name

Is This Answer Correct ?

0 Yes

0 No

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

Answer / yunus

select top(5) * from tablename

Is This Answer Correct ?

5 Yes

8 No

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

Answer / satish

select top 5 * from tablename

Is This Answer Correct ?

5 Yes

10 No