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.

SQL Cheatsheet | DevTools Surf

DevTools Surf

Example: SQL Cheatsheet

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

WHERE

Output

──────── SQL SELECT Cheatsheet ────────

SELECT * FROM table WHERE condition                        Filter rows with WHERE clause
SELECT * FROM table WHERE col IN (1, 2, 3)                 Match multiple values
SELECT * FROM table WHERE col LIKE '%pattern%'             Pattern matching (wildcards)
SELECT * FROM table WHERE col BETWEEN 10 AND 20            Range query
SELECT * FROM table WHERE col IS NULL                      Find null values
SELECT * FROM table WHERE col IS NOT NULL                  Find non-null values
SELECT * FROM table WHERE col1 = val AND col2 = val        Multiple conditions (AND)
SELECT * FROM table WHERE col1 = val OR col2 = val         Multiple conditions (OR)
SELECT * FROM table WHERE NOT (condition)                  Negate condition
SELECT * FROM table WHERE (col1, col2) IN ((a,b), (c,d))   Multiple column IN clause

About SQL Cheatsheet

SQL Cheatsheet preview - Cheatsheets tool

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

Use Cases

Looking up window function syntax for complex reporting queries
Referencing JOIN types when optimizing slow database queries
Finding upsert syntax differences between PostgreSQL and MySQL
Reviewing aggregate functions when building dashboard analytics

Tips

Check the JOIN section to pick the right join type
Review window functions for advanced analytics queries
Use the aggregates section for GROUP BY and HAVING patterns

Fun Facts

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.

FAQ

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.

Related Cheatsheets Tools

Git Cheatsheet Docker Cheatsheet Makefile Cheatsheet Regex Cheatsheet Markdown Cheatsheet Vim Cheatsheet Bash / Shell Cheatsheet kubectl Cheatsheet