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

0 vote264 views2 answers
Mysql calcular idade
SQL
0 vote263 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote233 views1 answer
Mysql database is not starting in xampp
SQL
0 vote257 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote253 views1 answer
Postgresql alter column nullable
SQL
0 vote279 views1 answer
Insert using condition postgres
SQL
4 votes248 views1 answer
Sql delete where in select
SQL
0 vote232 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote272 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote249 views1 answer
Mysql query to add hours to column in table
SQL