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 vote155 views1 answer
Safe mysql
SQL
3 votes132 views2 answers
Current year sql
SQL
4 votes145 views2 answers
Sql offset
SQL
0 vote142 views1 answer
Oracle shrink table
SQL
0 vote149 views2 answers
Null value in column violates not-null constraint
SQL
0 vote140 views1 answer
Mysql query to add hours to column in table
SQL
23 votes142 views4 answers
Sql server substring
SQL
0 vote129 views1 answer
Mysql sleep connections
SQL
0 vote147 views1 answer
How to display value of variable in mysql
SQL
0 vote138 views1 answer
Php delete database
SQL