ADVERT

SQL Cheatsheet

SQL command reference for SELECT queries, filtering, joins, aggregation, schema changes, and performance tips.

Reference controls

Search SQL snippets

Generate a clean SELECT template and copy it into your editor.

TableColumnsWHEREORDER BYLIMIT

SELECT id, customer_id, total FROM orders
WHERE status = 'paid'
ORDER BY created_at DESC
LIMIT 50;

Query patterns for projections and sorting.

Query	Purpose	Notes
`SELECT id, email FROM users ORDER BY created_at DESC LIMIT 50;`	Sample data	Limit previews and avoid SELECT * in production endpoints.
`SELECT DISTINCT country FROM orders;`	Unique values	DISTINCT applies to the full set of selected columns.
`SELECT * FROM events WHERE occurred_at >= NOW() - INTERVAL '7 days';`	Date filtering	Relative date syntax varies by dialect.

Combine entities and summarize metrics.

Query	Purpose	Notes
`SELECT o.id, c.name FROM orders o JOIN customers c ON c.id = o.customer_id;`	Inner join	Returns rows where both sides match the ON condition.
`SELECT p.id, c.id FROM posts p LEFT JOIN comments c ON c.post_id = p.id;`	Left join	Retains parent rows when child rows are missing.
`SELECT city, COUNT() AS total FROM users GROUP BY city HAVING COUNT() > 100;`	Group and HAVING	Use HAVING for aggregate filters after GROUP BY.

DDL and mutation snippets used in migrations and services.

Query	Purpose	Notes
`CREATE TABLE accounts ( id BIGSERIAL PRIMARY KEY, email TEXT UNIQUE NOT NULL, created_at TIMESTAMPTZ DEFAULT NOW() );`	Create table	Define defaults and constraints up front.
`INSERT INTO inventory (sku, qty) VALUES ($1, $2) ON CONFLICT (sku) DO UPDATE SET qty = EXCLUDED.qty;`	Upsert	Conflict syntax is dialect-specific.
`BEGIN; UPDATE accounts SET balance = balance - 20 WHERE id = 1; COMMIT;`	Transaction	Protect multi-step writes from partial failures.

Choose a SQL dialect to view syntax variants for PostgreSQL, MySQL, or SQLite.
Search by purpose, notes, or query text to narrow down the reference table quickly.
Use the query builder to generate a SELECT template, then copy and adapt it in your project.

Each example row includes per-dialect SQL where syntax differs.
Coverage includes SELECT patterns, joins, aggregation, DDL, upsert, and transactions.
Notes call out common pitfalls such as aggregate filtering and date syntax variance.

The builder composes table, columns, filters, ordering, and limit into a clean SELECT statement.
Use it as a starting scaffold for endpoint queries and debugging sessions.
Copy output directly for faster iteration in editors and query consoles.

Can I switch dialects without losing my builder values?: Yes. Dialect changes update reference snippets while preserving current builder input state.
Does this validate or execute SQL against a database?: No. This tool is a local reference and query template generator, not a database client.
Are these snippets production-ready as-is?: They are practical templates; adjust naming, indexing, constraints, and security filters for your schema.

ADVERT