On Sat, Mar 15, 2008 at 4:37 PM, Richard Broersma < [EMAIL PROTECTED]> wrote:
> On Sat, Mar 15, 2008 at 4:21 PM, mark <[EMAIL PROTECTED]> wrote: > > > > select * from users where session_key is not Null order by id offset > > OFFSET limit 300 > > > > One solution is to retain the last ID from the previous scan: > > SELECT * > FROM Users > WHERE session_key IS NOT NULL > AND id > your_last_id > LIMIT 300; > will this ensure that no row is repeated when i itereate over the table? what are the rows ordered by? thanks
