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 vote318 views1 answer
Oracle flush Shared Pool
SQL
0 vote328 views1 answer
How to select only id where is not in column mysql
SQL
0 vote306 views1 answer
How to connect to mysql in ef 6
SQL
2 votes320 views1 answer
Node and mysql like
SQL
4 votes301 views2 answers
Oracle set date format
SQL
0 vote337 views1 answer
Name '_mysql' is not defined
SQL
0 vote326 views1 answer
Sql server select value large text
SQL
1 vote359 views3 answers
Date_add mysql
SQL
36 votes389 views6 answers
Change column data type sql
SQL
2 votes329 views1 answer
How to find constraints on a table in oracle
SQL