Sql limit order by

-- MySql
SELECT * FROM emp ORDER BY sal DESC LIMIT 5;	
-- SQL Server 
SELECT TOP 5 * FROM emp ORDER BY sal DESC;	
-- Oracle < 11g 
SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5;
-- Oracle 12c +
SELECT * FROM emp ORDER BY sal DESC FETCH FIRST 5 ROWS ONLY;

Sql limit order by

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];

Source: techonthenet.com

Similar codes

1 vote326 views1 answer
Postgres power
SQL
0 vote409 views1 answer
Delet all record statment sql
SQL
0 vote339 views1 answer
Sql missing values
SQL
-1 vote322 views4 answers
Restart mysql server ubuntu
SQL
0 vote306 views1 answer
Order by number of character in sql
SQL
7 votes322 views2 answers
What is sql clause
SQL
0 vote330 views1 answer
Rails sql query converstion
SQL
2 votes338 views1 answer
Oracle trace file
SQL
0 vote320 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote313 views1 answer
Which lock mode is not available in sql
SQL