What is the difference between an inner join and a left join?

An inner join returns only rows that have a match in both tables. A left join returns every row from the left table and fills in nulls where the right table has no match.

When do I use WHERE versus HAVING?

WHERE filters individual rows before they are grouped, while HAVING filters the groups after aggregation. Use HAVING when your condition refers to an aggregate such as COUNT, SUM, or AVG.

How do I count rows per group?

Use GROUP BY with a COUNT aggregate, for example SELECT status, COUNT(*) FROM orders GROUP BY status. Add HAVING COUNT(*) > 10 to keep only the larger groups.

What is the order of SQL clauses in a SELECT?

The logical order is SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT — though the database evaluates FROM and WHERE before SELECT. The cheatsheet groups statements in this familiar reading order.

Does this work across MySQL, PostgreSQL and SQLite?

The core statements shown are standard SQL and work across the major databases. A few features like LIMIT syntax or specific functions vary by engine, so check your database's docs for those.

Is anything I search or copy uploaded?

No. The entire cheatsheet and search run in your browser, so nothing you type or copy is sent anywhere.

SQL Cheatsheet — Gera Tools

A fast, searchable reference for the SQL you write most days. Statements are grouped so you can jump straight to the right pattern: querying with SELECT, filtering with WHERE, sorting and grouping, aggregates, joins, writing data (INSERT, UPDATE, DELETE), and schema changes. Each entry has a plain-English description and a one-click copy button.

How it works

Type a keyword or describe the task — join, group by, insert, index — and the list filters in real time to matching statements. Click Copy on any one to put it on your clipboard, then adapt the table and column names in your own database client. Nothing is executed here; it is a reference you paste from.

Example

Looking for grouped counts, search group by and you will find patterns such as:

SELECT status, COUNT(*) AS total
FROM orders
GROUP BY status
HAVING COUNT(*) > 10
ORDER BY total DESC;

Topic	Example statement
Querying	`SELECT * FROM users;`
Filtering	`... WHERE created_at >= '2026-01-01'`
Joins	`... a JOIN b ON a.id = b.a_id`
Writing	`UPDATE users SET active = false WHERE id = 7;`

Everything runs in your browser; nothing you type or copy is uploaded.