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

0 vote181 views1 answer
Get who is hired in specific month in sql
SQL
0 vote203 views2 answers
Timing sql queries
SQL
6 votes192 views5 answers
Mysql get last insert id
SQL
2 votes188 views1 answer
Get first n letter of department name in sql
SQL
0 vote190 views1 answer
How to install sql in anaconda
SQL
0 vote185 views1 answer
C# mysql update statement set value to null
SQL
0 vote187 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote190 views1 answer
Oracle list constraints
SQL
1 vote188 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote218 views1 answer
Finding leap year in sql
SQL