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

2 votes355 views1 answer
Select * from table where name like
SQL
0 vote386 views1 answer
Oracle sql all days except weekends
SQL
0 vote352 views1 answer
How to combine rows in sql server procedure
SQL
0 vote349 views1 answer
Sql last 7 days
SQL
8 votes353 views3 answers
Mysql alter table add index
SQL
1 vote344 views10 answers
Stack overflow
SQL
0 vote331 views1 answer
Oracle list dblink
SQL
1 vote385 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
5 votes393 views4 answers
Upload database mysql command line
SQL
0 vote433 views1 answer
Mariadb change column type
SQL