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? When i ask this you need to know that Im using PHP in web environment and try do this to get more performens from the script (now the script fetch all rows, then jump to needed row)
- Re: [SQL] fetching rows Nikolay Mijaylov
- Re: [SQL] fetching rows Jeff Hoffmann
- Re: [SQL] fetching rows Martin Christensen
- Re: [SQL] fetching rows Robert B. Easter
- [SQL] how many rows? [was Re: fetching row... Arnaud Vandyck
- Re: [SQL] how many rows? [was Re: fetc... Robert B. Easter
- Re: [SQL] how many rows? [was Re: fetc... Johann Spies
- Re: [SQL] fetching rows Decio Fonini
- Re: [SQL] fetching rows K Parker