Cheat sheets › SQL Query Reference

SQL Query Reference

Execution order, join mechanics, aggregations, windowing functions, and common anti-patterns.

• SQL
• Databases
• Analytics
• Backend

Open this cheat sheetMake your own

What is inside

• Logical Execution Order
• Table Joins
• Grouping and Aggregates
• Window Functions
• Window Frame Definitions
• CTEs and Deduplication
• Common SQL Pitfalls
• Index Sargability Traps
• Test Yourself

This is a ready-made, printable cheat sheet that fits 2 pages. Open it in CramSheet to read it, change anything, pick a layout and paper size, then print it or save it as a PDF. It opens as your own copy and works in your browser.

Related cheat sheets

• Data Tidying with tidyr and dplyr: A Reference SheetReshape, join, summarise and plot with tidyr, dplyr, stringr and ggplot2, with pandas…
• REST API Design & HTTP Status ReferenceStandard status codes, resource modelling, idempotent operations, and production…