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 vote203 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote221 views1 answer
Sql create table with references not primary key
SQL
0 vote184 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote186 views1 answer
Grab all records from one table to another oracle sql
SQL
16 votes206 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes248 views1 answer
Apex call duration
SQL
1 vote181 views3 answers
Get all tables postgres
SQL
0 vote197 views1 answer
Postgresql using reserved word as column name
SQL
5 votes251 views3 answers
Create function in postgresql
SQL
1 vote134 views1 answer
Metada in sql
SQL