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 vote97 views1 answer
Oracle gather table statistics
SQL
3 votes107 views2 answers
Mysql HAVING
SQL
16 votes123 views3 answers
Get count of duplicate records
SQL
10 votes103 views1 answer
Query to find object dependencies in oracle
SQL
1 vote98 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote105 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote100 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote111 views1 answer
Sql search all columns of database oracle sql
SQL
2 votes108 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote111 views2 answers
Import .sql into postgres db command
SQL