Skip to main content
kitlocal.dev

SQL Cheatsheet

Runs locally

100% processed in your browser. Inputs and outputs never leave your device.

Quick reference for SQL syntax, joins, functions, and data types

How it works

SQL evaluates logically as FROM/JOIN -> WHERE -> GROUP BY -> HAVING -> SELECT/WINDOW -> DISTINCT -> ORDER BY -> LIMIT, even though `SELECT` is written first.

Survival kit

The few commands to learn first.

42 commands

Keyboard shortcuts/Focus searchJKMove selectionCCopy selectedFBookmark selectedEscClear search

Select, Filter & Pagination

Filter predicates safely, avoid NULL traps, sort, and paginate efficiently.

  • Essential

    Filter rows, sort deterministically, and cap returned rows

    SELECT <cols> FROM <table> WHERE <cond> ORDER BY <col> DESC LIMIT <n>;

    Build the command

    SELECT <cols> FROM <table> WHERE <cond> ORDER BY <col> DESC LIMIT <n>;

    Values are inserted exactly as typed. Quote them yourself if they contain spaces or special characters.

    When to use it

    Adding a tie-breaker column to `ORDER BY` guarantees repeatable pagination order.

    Example

    SELECT id, email, created_at FROM users WHERE status = 'active' ORDER BY created_at DESC, id DESC LIMIT 25;

Joins & Set Operations

Combine related tables cleanly and find orphan or unmatched rows.

Aggregation, CTEs & Window Functions

Group metrics, stage readable queries with CTEs, and rank without collapsing rows.

Insert, Upsert, Update & Delete

Write idempotent mutations safely inside transactions without locking accidents.

Schema, Constraints, JSON & Performance

Design tables, composite indexes, JSON queries, and inspect EXPLAIN plans.

Try it in a KitLocal tool