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 |
how many tables will create when we create table, what are they? : Sql dba
What is record variable?
how is myisam table stored? : Sql dba
What are character functions in sql?
what is meant by nl2br()? : Sql dba
How do I view stored procedures?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Can triggers stop a dml statement from executing on a table?
How many databases can sql express handle?
What is the cause of mutating table error and how can we solve it?
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?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)