SQL Pagination Without OFFSET
A compromise solution for reasonably efficient pagination on databases like SQLite, MS SQL, Firebird, Oracle, and DB2 where OFFSET is either missing or merely an alias for "retrieve and immediately discard".
This is for situations which don't lend themselves to using a WHERE clause on your ORDER BY column.
Written by Stephan Sokolow
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Sql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#