How to split the result into pages, like 'limits' in MySQL? (PHP4+Oracle 8i)
Jan 20th, 2001 19:01
Alistair McElligott, Petr Kocian, Wenjun Shen,
You have to use subselect. The inner query selects all records and
every record will get its number rn. The outter query then selects just
required interval of records.
to select records from 51 to 100 use condition like this:
SELECT * FROM
(SELECT some_fields, ROWNUM rn FROM some_table)
WHERE rn BETWEEN 51 AND 100
Important is to use alias of the ROWNUM field in the inner query.
This sollution is a little uneffective because the inner query will
select all records.
This approach doesn't work if you have an order-by clause, as the
ordering (on the subquery) is performed _AFTER_ the row numbers are