Community

Public Snippets 1

Code shared by the SaveSnippets community — browse, copy, and get inspired.

#limit Clear
Tags #php #kotlin #bash #go #sql #rust #typescript #html #java #python #files #utils #strings #http #concurrency #async #json #arrays #security #types #crypto #database #dates #format
SQL Pagination with LIMIT / OFFSET
`LIMIT N OFFSET M` is universal — but degrades on deep pages (the DB still has to scan past M rows). Keyset (cursor) pagination is much faster for huge tables.
#sql #pagination #limit #offset #keyset
admin @admin ADMIN 4m ago 0
View