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 vote147 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote179 views1 answer
Sql server system messeges
SQL
0 vote122 views1 answer
Zerar auto increment mysql
SQL
1 vote119 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote117 views1 answer
Mysql workbench indent formatting
SQL
0 vote124 views1 answer
Mysql repair a table
SQL
0 vote139 views1 answer
Sql remove first character from string
SQL
14 votes134 views2 answers
Oracle add attribute to table
SQL
0 vote144 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote118 views1 answer
Opensuse stop MySQL
SQL