posted 19 years ago
Hi All,
I am trying to implement pagination in my reports using SQl queries.
My query is as follows
This works perfectly fine until I want to sort on the cust_id column of my table.
I am assuming that the query will be
This returns results like
Now when I query for the next set of records with
I get
How do I ensure that I get all rows with Cust Ids 1 in the first query and then all
with Cust ids 4 in the next query ?
Any help in this regard will be appreciated.
Thanks !!