Skip to content

Instantly share code, notes, and snippets.

@Mohamedelbechir

Mohamedelbechir/pagination_example.sql

Forked from ssokolow/pagination_example.sql
Created April 5, 2021 21:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Mohamedelbechir/2c3b0acf8483a3e5b429f7c2ed56bb03 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Mohamedelbechir/2c3b0acf8483a3e5b429f7c2ed56bb03 to your computer and use it in GitHub Desktop.
Download ZIP
Reasonably efficient pagination without OFFSET (SQLite version)
Raw
pagination_example.sql
-- 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment