Oracle sql limit results

-- 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;

Sql oracle limit

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

Source: stackoverflow.com

Similar codes

18 votes104 views6 answers
Drop table if exists
SQL
1 vote113 views1 answer
Insert pg result of select
SQL
1 vote122 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote99 views1 answer
Sql developer search all packages for text
SQL
8 votes104 views1 answer
Sql limit results returned
SQL
0 vote102 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote92 views1 answer
Sql Split string function
SQL
0 vote95 views1 answer
Check if a word appears at the end sql query
SQL
0 vote113 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
15 votes104 views6 answers
Psql
SQL