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

-2 votes214 views2 answers
Sqlserver docker
SQL
0 vote227 views1 answer
Mysql search like but first exact match
SQL
0 vote223 views1 answer
Mysql default uuid
SQL
1 vote216 views1 answer
Import mysql dump database command line linux
SQL
0 vote203 views1 answer
Dasebase_url-postgres for windows
SQL
12 votes242 views4 answers
How to check mysql version ubuntu
SQL
10 votes217 views2 answers
Sql rtrim
SQL
1 vote229 views1 answer
Cannot drop database because it is currently in use
SQL
7 votes229 views4 answers
Lowest salary in sql
SQL
0 vote217 views2 answers
Mysql on update current_timestamp
SQL