How to select top 5 coloumn from a table without using
coloumn name
Answer Posted / dj
Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does indexation mean?
How to transfer data from a cursor to variables with a "fetch" statement?
Do you know what is a trace frag? Where do we use it?
What is user-defined functions? What are the types of user-defined functions that can be created?
How many databases Microsoft SQL server provides?
Do you know how to send email from database?
What is indexing a document?
What is difference between equi join and inner join?
Explain the dirty pages?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How can I add Reporting Services reports to my application?
what are different types of raid configurations? : Sql server database administration
Can we insert data into view sql server?
What do you mean by authentication modes in sql server?
Can group functions be used in the order by clause in ms sql server?