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

0 vote336 views1 answer
Min salary in sql
SQL
4 votes343 views2 answers
Bulk kill mysql processlist
SQL
0 vote354 views1 answer
Formatting code with SQL Developer
SQL
1 vote356 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote338 views1 answer
Laravel eloquent get generated sql
SQL
0 vote343 views1 answer
Count characters of string mysql
SQL
9 votes373 views3 answers
Mysql run sql file
SQL
3 votes357 views2 answers
Install mysql powershell
SQL
0 vote417 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote337 views1 answer
Mysql limit results to 10
SQL