Create a gist now

Instantly share code, notes, and snippets.

Reasonably efficient pagination without OFFSET (SQLite version)
-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6
SELECT foo, bar, baz, quux FROM table
WHERE oid NOT IN ( SELECT oid FROM table
ORDER BY title ASC LIMIT 50 )
ORDER BY title ASC LIMIT 10
@dalethestirling

Just what I was looking for thanks for sharing

@aimanbaharum

Helpful 7 years old script!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment