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

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..

Answer / dj

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..

Answer / sudharshan

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

Post New Answer

More SQL Server Interview Questions

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,


Can you explain various data region available in ssrs with their use?

0 Answers  


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  


How do I list the available tables in a database I'm querying?

4 Answers  


How does index makes search faster?

0 Answers   QuestPond,






What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  


What is the sql case statement used for? Explain with an example?

0 Answers  


State the difference between local and global temporary tables?

0 Answers  


What is the bookmark lookup and rid lookup?

0 Answers  


What is the openxml statement in sql server?

0 Answers  


what is nonclustered index

0 Answers  


What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  


Categories