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

15 votes130 views6 answers
Psql
SQL
3 votes152 views2 answers
How to modify rows in SQL Server
SQL
0 vote132 views1 answer
How to find top 3 salary in sql
SQL
2 votes126 views1 answer
Mysql last 7 days including today
SQL
0 vote131 views1 answer
Drop all procedures sql server
SQL
0 vote144 views1 answer
Python sqlalchemy connection show server
SQL
0 vote112 views1 answer
Get who is hired in month in sql
SQL
12 votes154 views1 answer
Create column sql server
SQL
0 vote151 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote123 views1 answer
Oracle query to see what scema i am working in
SQL