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

24 votes228 views4 answers
Mssql get all table names
SQL
1 vote243 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote239 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote218 views1 answer
Postgres add prefix to primary key
SQL
-1 vote246 views1 answer
Round up and down sql
SQL
0 vote242 views1 answer
Insert output identity
SQL
9 votes253 views3 answers
Import DB through mysql console
SQL
0 vote246 views1 answer
Helptext in sql
SQL
0 vote248 views1 answer
Create table as select sql server error
SQL
0 vote244 views1 answer
Sql stored procedure update if parameter is not null
SQL