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 vote124 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote125 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
37 votes305 views3 answers
Sql check duplicate value in column
SQL
2 votes148 views1 answer
Oracle kill session by sql_id
SQL
0 vote126 views1 answer
Get null value in sql
SQL
6 votes130 views2 answers
Join vs union
SQL
0 vote136 views1 answer
Alter table change default
SQL
0 vote118 views1 answer
First mysql
SQL
12 votes124 views4 answers
Mysql version
SQL
3 votes123 views4 answers
Truncate syntax in sql
SQL