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

1 vote145 views1 answer
Mysql take number in string
SQL
0 vote130 views1 answer
Get sum sqlite android
SQL
0 vote144 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote90 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote146 views1 answer
Difference between 2 query results sql server
SQL
0 vote147 views1 answer
Sort by last two number sql
SQL
0 vote135 views1 answer
2020 new year
SQL
1 vote156 views1 answer
How to run parallel queries in sql server with entity framework
SQL
2 votes142 views1 answer
Set username and password for postgresql database
SQL
0 vote149 views1 answer
Mysql insert into select with recursive
SQL