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 are types of scd? : sql server analysis services, ssas

975

What is table constraint?

932

What is the current limitation of the size of SQL Azure DB?

124

How to recover from sql injection? : sql server security

958

How to view existing indexes on an given table using sp_help?

1055

What are the export options of ssrs?

165

What are the elements of dbms?

923

How to create a view on an existing table in ms sql server?

1054

What is a collation?

1038

What methods do you follow to protect from sql injection attack?

971

Is truncate a dml command?

892

What is the use of partition by in sql server?

884

wat wil hapn if we give the both read and deny read permission to user?

2063

Why people hate cursor?

1096

What is temporary table in sql server? Why we use temp table?

908