Skip to content

Snippets Tutorials Premium About

Home
Categories
SQL

SQL snippets

Queries for PostgreSQL and other relational databases.

Loading snippets…

GreenSnippets — Find it. Copy it. Ship faster.

Privacy Terms Licensing Affiliate disclosure Contact

15 snippets

SQL Tested
Keyset (cursor) pagination instead of OFFSET
Page through large tables quickly and stably by filtering on the last seen sort key.
SQL Tested
Find duplicate rows by one or more columns
List values that appear more than once with GROUP BY and HAVING, including how many times.
SQL Tested
Delete duplicate rows but keep the newest
Remove duplicates in PostgreSQL using ROW_NUMBER over a partition, keeping one row per key.

PreviousPage 2 of 2