5 min read
The SQL CASE statement: simple vs searched syntax, with examples
How the SQL CASE statement works: simple vs searched syntax, real examples for PostgreSQL, MySQL and SQL Server, and the three mistakes everyone makes.
Read the guideSQL, explained in plain English
Short guides to the SQL questions people actually get stuck on — no jargon, small examples you can run, and the mistakes to watch for.
5 min read
INNER JOIN vs LEFT JOIN: the difference, in plain English
A plain-English guide to SQL join types — INNER, LEFT, RIGHT and FULL — with small examples showing exactly which rows each one keeps.
Read the guide5 min read
GROUP BY explained: why SQL keeps rejecting your columns
Why GROUP BY complains about columns that are not in the group, how HAVING differs from WHERE, and how to count and sum correctly.
Read the guide6 min read
Why is my SQL query slow? Seven things to check first
A practical checklist for slow SQL queries: missing indexes, functions on filtered columns, SELECT *, OR conditions, N+1 patterns and how to read a query plan.
Read the guide4 min read
NULL in SQL: why your WHERE clause silently drops rows
NULL is not zero and not an empty string. How IS NULL, COALESCE, NOT IN and aggregates behave — and how to stop NULL from quietly removing rows.
Read the guideRather not write the SQL yourself?
Describe what you need in plain English and SQLGenie writes the query, checks it against your tables and explains it. Free, no account needed.
Generate SQL free