SQL

SQL Cheat Sheet

Common SQL patterns for reading and filtering data. Format messy queries with FreeToolMate SQL tools — everything runs in your browser.

SELECT basics

SELECT id, name, created_at
FROM users
WHERE active = 1
ORDER BY created_at DESC
LIMIT 20;

JOIN

SELECT u.name, o.total
FROM users u
INNER JOIN orders o ON o.user_id = u.id
WHERE o.status = 'paid';

Useful clauses

• WHERE — filter rows
• GROUP BY / HAVING — aggregates and filters on groups
• ORDER BY — sort ascending or descending
• LIMIT / OFFSET — page results
• DISTINCT — unique values
• LIKE / IN / BETWEEN — common predicates

Aggregates

SELECT country, COUNT(*) AS users, AVG(age) AS avg_age
FROM users
GROUP BY country
HAVING COUNT(*) > 10;

Format SQL online

• SQL Formatter — pretty-print a query
• SQL Beautifier — readable indentation
• SQL Validator — catch basic syntax issues

All articles · SQL Tools hub