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

Answer Posted / yunus

select top(5) * from tablename

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create new tables with "select ... Into" statements in ms sql server?

504


Explain temporary table vs table variable by using cursor alternative?

514


What is the use of stored procedure?

508


Does sql server use java?

512


Can we insert data if clustered index is disabled?

502






How do I create a stored procedure in dbml?

510


What are “phantom rows”?

1235


What do you understand by coalesce in sql server?

493


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1088


What is the difference between ‘having’ clause and a ‘where’ clause?

539


Explain how you can configure a running aggregate in SSRS?

109


What is the difference between implicit and explicit transaction?

554


How much is a sql server license?

498


What are the lambda triggers?

478


What are synonyms?

522