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

15 votes323 views1 answer
Mysql int range
SQL
0 vote283 views1 answer
Mariadb list tables
SQL
0 vote313 views1 answer
Mssql view column data type
SQL
0 vote323 views1 answer
Mysql DDL
SQL
3 votes284 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
17 votes336 views6 answers
What is cursor in sql server with example
SQL
0 vote343 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote305 views1 answer
Sql select first and last record of each group
SQL
1 vote330 views1 answer
Sql dcl
SQL
0 vote351 views1 answer
Pgadmin save data greyed out
SQL