Sql oracle limit

Oracle sql limit results

-- 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;

Sql oracle limit

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

Source: stackoverflow.com

SQL SELECT TOP Equivalent in oracal

syntax -> SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number 
////example///
SELECT *
FROM Persons
WHERE ROWNUM <=5

Rownum in sql

SELECT ROWNUM, a.*
FROM (SELECT customers.*
      FROM customers
      WHERE customer_id > 4500
      ORDER BY last_name) a;

Source: techonthenet.com

Similar codes

0 vote183 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
22 votes149 views4 answers
Show list of users in mysql
SQL
2 votes152 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote177 views10 answers
John the ripper mysql
SQL
1 vote104 views1 answer
Python escape string for sql
SQL
1 vote169 views2 answers
Create a unqie constraint mysql
SQL
4 votes150 views1 answer
Oracle delete last row
SQL
0 vote149 views1 answer
Sql delete from with relation
SQL
2 votes110 views1 answer
Oracle current date without time
SQL
0 vote156 views1 answer
Get db connection detail from sql developer profile
SQL