SQL Cheat Sheet – Ultimate Developer Reference 2024

Jump To Section

Use the Ctrl + F shortcut to quickly find specific commands in this cheat sheet.

Queries

Concept / Tag	Code Snippet	Description
Distinct	`SELECT DISTINCT country FROM users;`	Unique values only.
Like	`SELECT * FROM u WHERE name LIKE "A%";`	Pattern matching.

Concept / Tag	Code Snippet	Description
Group By	`SELECT dep, count(*) FROM u GROUP BY dep;`	Categorize counts.
Having	`SELECT ... HAVING count(*) > 10;`	Filter aggregates.

Concept / Tag	Code Snippet	Description
Full Join	`SELECT * FROM t1 FULL OUTER JOIN t2 ON ...;`	All records from both.

Concept / Tag	Code Snippet	Description
Update	`UPDATE users SET active = 1 WHERE id > 0;`	Modify data.
Delete	`DELETE FROM logs WHERE created_at < NOW();`	Remove data.

HTML Guide

CSS Guide

JavaScript Guide