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 vote281 views1 answer
Mysql add comment to column
SQL
0 vote276 views1 answer
Month mysql
SQL
0 vote294 views1 answer
Frename oracle
SQL
5 votes253 views1 answer
Postgres upsert
SQL
4 votes323 views3 answers
Sql find second highest salary employee
SQL
0 vote305 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote328 views1 answer
How to inner join 4 tables in sql
SQL
7 votes268 views4 answers
How to reset the identity column in sql server
SQL
3 votes303 views2 answers
How to open postgresql in windows
SQL
0 vote297 views1 answer
How to query without duplicate rows in sql
SQL