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 vote377 views1 answer
Mysql record group by created date count
SQL
2 votes375 views6 answers
Mysql change timezone
SQL
0 vote384 views1 answer
Add super privilege mysql
SQL
0 vote333 views1 answer
Convert rows into columns in oracle
SQL
0 vote356 views1 answer
Edit a field mysql terminal
SQL
5 votes349 views2 answers
Oracle list columns schema
SQL
0 vote339 views1 answer
Inner joint
SQL
0 vote354 views1 answer
Sql replace id with name from another table
SQL
0 vote344 views3 answers
Sql count condition
SQL
2 votes390 views1 answer
Python sql
SQL