Oracle limit rows

-- 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;

Similar codes

0 vote314 views1 answer
How to write if case in select query in select statement
SQL
1 vote281 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote294 views1 answer
Sql server datetime to string
SQL
0 vote290 views1 answer
Insert into select with group by
SQL
0 vote295 views1 answer
Php select data from mysql database without column name
SQL
2 votes277 views1 answer
Install sqlite npm
SQL
0 vote284 views2 answers
Get all index postgres
SQL
0 vote296 views2 answers
Update query with between in mysql
SQL
0 vote281 views1 answer
Mysql command line ubuntu
SQL
3 votes290 views1 answer
Oracle revoke grant
SQL