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 vote225 views1 answer
Datagrip go to line
SQL
0 vote182 views1 answer
Mysql isshow
SQL
0 vote192 views1 answer
Psql list view rules
SQL
1 vote212 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote180 views1 answer
Initcap in sql
SQL
7 votes198 views1 answer
Buy forge mods server hosting
SQL
4 votes238 views1 answer
Mysql query first character
SQL
0 vote226 views1 answer
Enable outgoing remote MySQL access
SQL
25 votes205 views5 answers
Date in mysql
SQL
0 vote237 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL