SQL Cheat Sheet

Quick reference for common SQL commands and syntax.

Basic Queries

SELECT * FROM table_name;
SELECT column1, column2 FROM table_name WHERE condition;
SELECT * FROM table_name ORDER BY column_name ASC;
SELECT * FROM table_name LIMIT 10;

Joins

SELECT a.col1, b.col2
FROM table_a a
INNER JOIN table_b b ON a.id = b.a_id;

LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN

Data Manipulation

INSERT INTO table_name (col1, col2) VALUES (val1, val2);
UPDATE table_name SET col1 = val1 WHERE condition;
DELETE FROM table_name WHERE condition;

Aggregate Functions

SELECT COUNT(*), SUM(col), AVG(col), MIN(col), MAX(col)
FROM table_name
GROUP BY column1
HAVING COUNT(*) > 5;