Garett PHG gphg

I do code. I use this account main purpose is mostly to host my private codes and collaboration. I really messy at code; please no bulli. 😩

ssokolow / pagination_example.sql

Created December 23, 2009 13:02

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