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

1 vote126 views1 answer
Psql datetime grather than
SQL
1 vote133 views1 answer
Table valued functions in sql
SQL
0 vote138 views1 answer
Select into table variable
SQL
1 vote143 views1 answer
Mysql order by desc null last
SQL
1 vote128 views1 answer
Oracle lowercase
SQL
0 vote130 views1 answer
Sql delete from with relation
SQL
1 vote131 views1 answer
Sql select where id not exists in another table
SQL
13 votes132 views2 answers
Get date from now() mysql
SQL
0 vote141 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote130 views1 answer
Suse status MySQL
SQL