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 vote181 views1 answer
Resullt all update knex mysql
SQL
4 votes186 views1 answer
Datepart postgres
SQL
3 votes194 views2 answers
Mysql select database
SQL
1 vote174 views1 answer
Select 2 rows in sql
SQL
13 votes180 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
17 votes201 views4 answers
Postgres list users
SQL
0 vote176 views1 answer
Select insert new table sql server
SQL
2 votes184 views1 answer
Mysql Incorrect column specifier for column
SQL
3 votes180 views2 answers
Sql not contains
SQL
1 vote211 views1 answer
Create new table from old table
SQL