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 vote184 views1 answer
Oracle duration between timestamps
SQL
0 vote194 views1 answer
Redudancy in SQL
SQL
0 vote201 views1 answer
Postgres reorder columns
SQL
2 votes193 views1 answer
Get first 2 letter in sql
SQL
0 vote231 views1 answer
How to define a non primary composite key in sql
SQL
1 vote152 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote225 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote203 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
6 votes247 views3 answers
Check if string contains substring sql
SQL
0 vote201 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL