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 vote332 views1 answer
Group_concat only returns one row
SQL
0 vote322 views1 answer
Sql remove last 2 digit
SQL
0 vote360 views1 answer
Create synonym for dblink in oracle
SQL
27 votes345 views6 answers
Set password mysql
SQL
0 vote341 views1 answer
How to delete python anywhere mysql database
SQL
5 votes376 views2 answers
Mysql dump mysql db cli
SQL
6 votes333 views2 answers
Mysql get yesterday
SQL
3 votes336 views2 answers
Enter mysql command line
SQL
0 vote345 views1 answer
How to add boolean column in postgresql
SQL
0 vote322 views3 answers
Drop multiple columns in sql
SQL