Mysql limit rows

-- 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;

Similar codes

4 votes237 views1 answer
W3schools create table
SQL
0 vote247 views1 answer
T sql dynamic top n query
SQL
-1 vote220 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
12 votes223 views1 answer
Docker mysql random root password
SQL
4 votes205 views2 answers
Oracle set date format
SQL
0 vote232 views2 answers
Sql query for getting details by id
SQL
0 vote238 views1 answer
Mysql subtract month from timestamp
SQL
0 vote235 views1 answer
Sql developer search all packages for text
SQL
0 vote221 views1 answer
How to select even id in sql
SQL
1 vote227 views1 answer
Pentaho + pasar de excel a sql
SQL