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 vote115 views1 answer
Mysql search like but first exact match
SQL
0 vote131 views1 answer
Sql statement show all emails with dome
SQL
-3 votes108 views1 answer
Remove spaces sql 2008
SQL
0 vote112 views1 answer
Excute raw query
SQL
0 vote132 views2 answers
Compound operator in sql
SQL
1 vote114 views3 answers
Rename table snowflake
SQL
0 vote117 views1 answer
Sql get guid
SQL
0 vote151 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote145 views4 answers
Alter schema sql
SQL
9 votes115 views3 answers
Sql delete where in
SQL