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

What is difference between table aliases and column aliases? Do they affect performance?

1019

What is difference between temp table and cte?

1072

What are the different editions available in sql server 2000?

1112

Can a database be shrunk to 0 bytes, if not, why?

1162

Mention the different authentication modes in sql server.

1105

Explain about thread and memory management process of SQL?

1016

What are trace flags and mention a few common trace flags used with sql server?

1137

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

995

Explain transaction server distributed transaction?

1037

what are isolation levels? : Sql server database administration

1058

How do I find my localdb version?

1027

What is a user-defined function in the sql server and what is its advantage?

1141

How to declare and use cursor variables?

1252

What are the common performance issues in sql server?

971

Explain the flow of creating a cube? : sql server analysis services, ssas

1100