Nikolay Mijaylov wrote:
>
> Let say we have a select that returns 100 rows.
>
> I can fetch first 25 with simple sql:
>
> BEGIN WORK;
> DECLARE liahona CURSOR FOR SELECT * FROM films;
> FETCH [FORWARD] 25 IN liahona;
> CLOSE liahona;
> COMMIT WORK;
>
> but how I can fetch rows from 26 to 50? I mean withou fetching first 25. Or
> can I skip first 25?
you can't do that with a cursor, but you can use they mysql-ism called a
limit clause. for example, to fetch rows 26-50 from that query, you'd
do:
select * from films limit 25,26;
or
select * from files limit 25 offset 26;
--
Jeff Hoffmann
PropertyKey.com