Oracle LIMIT clause?

admin

Administrator
Staff member
In PostgreSQL, I can execute:

select * from mytable limit 5 offset 10;

I believe the equivalent in MySQL is:

select * from mytable limit 10,5

In whatever order the database returns rows, it only returns, of the entire set, the 5 rows start at row 10.


What is the equivalent of this in Oracle?
 
Back
Top