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 vote202 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote186 views1 answer
Dapper run sql script with parameters
SQL
3 votes208 views1 answer
Start mysql server linux terminal
SQL
0 vote196 views1 answer
Oracle service name view
SQL
4 votes213 views5 answers
Get last query in codeigniter 4
SQL
0 vote200 views1 answer
Can you write relational algebra into sql queries
SQL
-1 vote202 views1 answer
Concat two columns in sql server
SQL
7 votes192 views1 answer
Sql server management studio turn on line numbers
SQL
6 votes201 views2 answers
Oracle
SQL
0 vote191 views1 answer
Find invalid datetime field
SQL