What is the purpose of the sql select top clause?



What is the purpose of the sql select top clause?..

Answer / Dhan Pal Sahu

The SQL 'SELECT TOP' clause is used in Microsoft SQL Server to retrieve a specified number of rows from the top or bottom of a result set. This clause is not available in standard ANSI SQL; it is a proprietary extension provided by Microsoft.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how many tables will create when we create table, what are they? : Sql dba

0 Answers  


What is record variable?

1 Answers  


how is myisam table stored? : Sql dba

1 Answers  


What are character functions in sql?

1 Answers  


what is meant by nl2br()? : Sql dba

1 Answers  


How do I view stored procedures?

1 Answers  


what is the difference between rownum pseudo column and row_number() function? : Sql dba

1 Answers  


Can triggers stop a dml statement from executing on a table?

1 Answers  


How many databases can sql express handle?

1 Answers  


What is the cause of mutating table error and how can we solve it?

1 Answers  


What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,


What types of commands can be executed in sql*plus?

1 Answers  


Categories