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

5 votes157 views2 answers
Postgresql add not null constraint
SQL
0 vote134 views1 answer
Compare two tables to find unmatched records
SQL
1 vote140 views1 answer
Mysql f# examples
SQL
0 vote162 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote138 views1 answer
Oracle search in date columns
SQL
0 vote184 views1 answer
Table structure in sql
SQL
5 votes151 views1 answer
How to check port number for postgresql
SQL
4 votes127 views1 answer
Add constraint fk
SQL
0 vote129 views1 answer
Python sqlalchemy orm to select null values
SQL
9 votes125 views1 answer
Mysql check date range
SQL