Doing it this way is known as the seek method/"keyset pagination" and it's also quicker when you're quite deep in the list: http://use-the-index-luke.com/sql/p

Doing it this way is known as the seek method/"keyset pagination" and it's also quicker when you're quite deep in the list: http://use-the-index-luke.com/sql/partial-results/fetch-next-page http://use-the-index-luke.com/sql/partial-results/fetch-next...