Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Slow for large offsets SELECT id, name FROM users ORDER BY id LIMIT 20 OFFSET 100000; -- Keyset pagination (fast) SELECT id, name FROM users WHERE id > 100020 -- last seen id ORDER BY id LIMIT 20;
Result
Open