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 vote174 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote207 views1 answer
Repeatable read trong sql server
SQL
0 vote140 views1 answer
Print sum of values sql
SQL
3 votes175 views1 answer
Oracle list user grants
SQL
0 vote192 views1 answer
Default password for mysql_secure_installation in mac
SQL
22 votes237 views4 answers
Date format mysql
SQL
-1 vote269 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote180 views1 answer
Search starting with mysql
SQL
0 vote203 views1 answer
SQL Where-Klausel
SQL
10 votes189 views2 answers
Show tables in schema oracle
SQL