Select Top(5) COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS Where TABLE

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

Question Posted / dj

Answer Posted / dj

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to backup encryption key ?

185

How do you implement session management in SQL Server mode?

1109

What is 2nf example?

999

Is the primary key column of a table an index in ms sql server?

962

What is the meaning of resultset type_scroll_insensitive?

956

What is cursor in ms sql server?

1153

What is raid, and how it can influence database performance?

1058

What are the features of Embedded SQL

1133

What is identity?

1019

How many full-text indexes can a table have?

974

How you can change the database name in SQL SERVER?

1194

What is the cartesian product of table?

1011

What is tabulation?

956

Explain the disadvantages/limitation of the cursor?

963

What is SQL Azure Firewall?

136