Common ANSI + Postgres-flavored. Dialect-specific features (MySQL's ON DUPLICATE KEY, SQLite's UPSERT) are noted when they differ.

Does it cover window functions?

Yes — OVER, PARTITION BY, ORDER BY, ROWS BETWEEN, and the common uses (running totals, LAG/LEAD, ranking).

What about CTEs and recursion?

Yes — WITH syntax, recursive CTEs for tree traversals, and the 'materialized' hint.

Brief — varies heavily by dialect (Postgres, MySQL 8+, SQL Server JSON functions). See the PostgreSQL Cheatsheet for Postgres-specific JSONB.

SELECT, JOIN, aggregates, window functions, upsert. Part of the DevTools Surf developer suite. Browse more tools in the Cheatsheets collection.

SQL was developed at IBM by Donald Chamberlin and Raymond Boyce in 1974, originally called SEQUEL (Structured English Query Language).
The name was changed from SEQUEL to SQL due to a trademark conflict with Hawker Siddeley, a British aircraft company.
PostgreSQL has been in continuous development since 1986, originally called POSTGRES by Michael Stonebraker at UC Berkeley.

Which SQL dialect?: Common ANSI + Postgres-flavored. Dialect-specific features (MySQL's ON DUPLICATE KEY, SQLite's UPSERT) are noted when they differ.
Does it cover window functions?: Yes — OVER, PARTITION BY, ORDER BY, ROWS BETWEEN, and the common uses (running totals, LAG/LEAD, ranking).
What about CTEs and recursion?: Yes — WITH syntax, recursive CTEs for tree traversals, and the 'materialized' hint.
JSON operators?: Brief — varies heavily by dialect (Postgres, MySQL 8+, SQL Server JSON functions). See the PostgreSQL Cheatsheet for Postgres-specific JSONB.

SELECT, JOIN, aggregates, window functions, upsert. Part of the DevTools Surf developer suite. Browse more tools in the Cheatsheets collection.

SQL was developed at IBM by Donald Chamberlin and Raymond Boyce in 1974, originally called SEQUEL (Structured English Query Language).
The name was changed from SEQUEL to SQL due to a trademark conflict with Hawker Siddeley, a British aircraft company.
PostgreSQL has been in continuous development since 1986, originally called POSTGRES by Michael Stonebraker at UC Berkeley.

Which SQL dialect?: Common ANSI + Postgres-flavored. Dialect-specific features (MySQL's ON DUPLICATE KEY, SQLite's UPSERT) are noted when they differ.
Does it cover window functions?: Yes — OVER, PARTITION BY, ORDER BY, ROWS BETWEEN, and the common uses (running totals, LAG/LEAD, ranking).
What about CTEs and recursion?: Yes — WITH syntax, recursive CTEs for tree traversals, and the 'materialized' hint.
JSON operators?: Brief — varies heavily by dialect (Postgres, MySQL 8+, SQL Server JSON functions). See the PostgreSQL Cheatsheet for Postgres-specific JSONB.