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 vote178 views1 answer
How to query without duplicate rows in sql
SQL
0 vote206 views3 answers
Postgres trim string
SQL
0 vote184 views2 answers
Disallowed function mysql to_date()
SQL
0 vote174 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote197 views2 answers
Mysql extract number from string
SQL
20 votes157 views1 answer
Sql change column types
SQL
0 vote170 views2 answers
How to update date in oracle
SQL
-2 votes175 views1 answer
Mysql see users and passwords
SQL
1 vote170 views1 answer
Mysql size int
SQL
0 vote164 views1 answer
Sql get month and year from date
SQL