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

2 votes207 views1 answer
Apex date today add days
SQL
5 votes204 views3 answers
String concatenation sql server
SQL
0 vote196 views2 answers
Find Overlapping sql
SQL
1 vote185 views3 answers
Remove unique key from a table
SQL
0 vote218 views2 answers
Sql stored procedure for access frontend
SQL
0 vote212 views1 answer
Mysql update set sum
SQL
0 vote212 views1 answer
Update and keep original value sql
SQL
1 vote212 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote196 views1 answer
Inser into example
SQL
0 vote203 views1 answer
Error code 1215 cannot add foreign key constraint
SQL