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

4 votes304 views1 answer
Change nls_date_format
SQL
0 vote435 views1 answer
Sql developer export connections
SQL
1 vote316 views1 answer
Mysql strict_trans_tables
SQL
0 vote313 views1 answer
Print mysql
SQL
0 vote296 views1 answer
Sql row number in result set
SQL
1 vote297 views1 answer
Apex run 404
SQL
0 vote288 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote310 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote298 views2 answers
Create new table plsql
SQL
1 vote305 views1 answer
Postgres get month name from date
SQL