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 vote234 views1 answer
Restart sql server command line linux
SQL
1 vote229 views1 answer
Increasing font and zooming in mysql workbench
SQL
2 votes238 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote239 views1 answer
Cross schema query oracle 2 users
SQL
5 votes246 views3 answers
Show indexes mysql
SQL
3 votes221 views2 answers
Coalesce mysql
SQL
0 vote231 views1 answer
Mysql locate
SQL
3 votes237 views1 answer
Define REGEXP?
SQL
1 vote231 views1 answer
Find a column in all tables postgres
SQL
1 vote228 views3 answers
Connection string mysql
SQL