SELECT top 5 * from information_schema.columns where table

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

Question Posted / aashish arora

Answer Posted / aashish arora

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you get second highest salary from the table?

964

What is normalization? Explain its different types?

1088

How many categories of data types used by sql server?

1018

what is spatial nonclustered index

992

Explain the difference between primary keys and foreign keys?

1023

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

SQL Server Architecture ?

2456

Tell me what is log shipping?

977

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1032

How to disable stored procedure sql server?

1606

What is the difference between a fill factor of 100 and 0?

981

Explain the relational database management system (rdbms)?

1097

What does dml stand for?

946

How do I find query history in sql server?

942

Can we add a cpu to sql server?

1011