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 vote197 views1 answer
Where not in array sql
SQL
0 vote179 views1 answer
Create user faunadb
SQL
1 vote171 views1 answer
Jooq convert using gbk
SQL
0 vote177 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote191 views1 answer
Select sql in descending order
SQL
-1 vote179 views1 answer
How to dump .csv file into mysql
SQL
1 vote197 views3 answers
Rows, INSERT INTO
SQL
0 vote180 views1 answer
Sql_inner_join
SQL
0 vote262 views1 answer
Create view in sql server that contain multiple select statements
SQL
3 votes185 views1 answer
Mysql replace string in table
SQL