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 vote254 views1 answer
Sql min
SQL
1 vote415 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote267 views1 answer
Oracle index hint
SQL
0 vote303 views1 answer
Create synonym for dblink in oracle
SQL
0 vote257 views1 answer
Selects all the columns from the sailors table
SQL
50 votes349 views6 answers
Sql duplicate rows
SQL
0 vote297 views5 answers
How to make trigger in phpmyadmin
SQL
5 votes266 views3 answers
Sql make column nullable
SQL
0 vote257 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
1 vote267 views1 answer
Truncate left characters mysql
SQL