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

2 votes232 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote225 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
2 votes250 views2 answers
Null column to 0 in mysql
SQL
1 vote222 views1 answer
Copy postgres table from one schema into another
SQL
1 vote197 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote220 views1 answer
Find a column in all tables postgres
SQL
0 vote225 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote220 views1 answer
Sql find record cannot cast date
SQL
4 votes195 views2 answers
Oracle set date format
SQL
10 votes214 views2 answers
Reset mysql root password mac
SQL