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

1 vote189 views1 answer
Firebase bigquery cloud message
SQL
0 vote205 views2 answers
Close external port 3306 with iptables
SQL
0 vote192 views1 answer
Oracle synonym procedure
SQL
18 votes200 views2 answers
Sql inner join
SQL
0 vote210 views1 answer
Mysql create table like
SQL
-1 vote249 views1 answer
Search all sql tables for a value
SQL
12 votes293 views4 answers
How to drop all tables in postgresql
SQL
0 vote200 views2 answers
How to tun mysql on ubunto
SQL
-1 vote216 views1 answer
Concat two columns in sql server
SQL
0 vote221 views1 answer
Difference between db.query and db.execute
SQL