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