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 like COUNT or SUM.

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

SQL cheatsheet — searchable reference

The everyday SQL statements, grouped so you can find them fast: querying with SELECT, filtering with WHERE, sorting & grouping, aggregates, joins, writing data (insert, update, delete) and schema changes. Each statement has a short plain-English description and a one-click copy button.

Search by keyword or by what you want to do — “join”, “group by”, “insert”, “index” — and copy the exact statement into your database client. Everything runs in your browser; nothing is uploaded.