Oracle limit rows

-- 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;

Oracle limit rows

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

Similar codes

0 vote118 views1 answer
Compare two tables to find unmatched records
SQL
2 votes140 views1 answer
Mariadb json select
SQL
0 vote230 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
1 vote123 views3 answers
Union SQL
SQL
4 votes119 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
13 votes129 views1 answer
Select count of distinct values sql
SQL
1 vote132 views1 answer
Error code 1292 mysql workbench
SQL
1 vote126 views1 answer
Mysql select if empty result
SQL
2 votes139 views2 answers
How to run postgresql in linux
SQL
5 votes155 views2 answers
Mysql dump mysql db cli
SQL