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 vote210 views1 answer
Systems sql
SQL
8 votes213 views1 answer
Oracle search source code
SQL
0 vote204 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote250 views1 answer
Finding leap year in sql
SQL
1 vote222 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
48 votes218 views3 answers
Psql create database
SQL
0 vote225 views1 answer
Oracle last connexion
SQL
4 votes202 views1 answer
Wilayah indonesia database
SQL
1 vote355 views3 answers
Sql subquery
SQL
1 vote224 views1 answer
Ubuntu access database from terminal
SQL