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

Answer Posted / sudharshan

set rowcount 5
select * from table_name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do you want to join software field as you have done your BE in Electronics?

1889


What is mean by dml?

734


How to create sub reports?

210


Explain full-text indexing?

693


What is transaction server consistency?

718






What is the difference between dropping a database and taking a database offline?

908


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

743


Which are ddl commands?

708


What are the types of indexing?

825


Is truncate autocommit?

718


What is the difference function and stored procedure?

720


How to install sql server 2005 express edition?

801


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

804


What is Dependency Injection and provide example?

814


Can we use where clause in union?

791