2
Contributors
3
Replies
20
Views
4 Years
Discussion Span
Last Post by pritaeas
0

LIMIT has two parameters, offset and rowcount:

LIMIT 0,5   -- first five
LIMIT 5,5   -- second five
LIMIT 10,5  -- third five
0

Yes I know about these but I want to have it done without using offset or Rowcount.

0

If you store the highest last used ID and use that in the next query (session variable), then it works like you showed. Just be sure you use ID in the order by too.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.