PostgreSQL Aggregates and Grouping Cheat Sheet
Summarize PostgreSQL data with count, sum, averages, filtered and ordered aggregates, HAVING, GROUPING SETS, ROLLUP, CUBE, and grouping indicators.
Open cheat sheetSQL · 9 guides
Querying and Joins
Retrieve, combine, aggregate, and navigate relational data.
Focused references
Querying and Joins cheat sheets
Each guide includes copy-ready syntax, detailed examples, and authoritative references.
PostgreSQL CTEs and Subqueries Cheat Sheet
Structure PostgreSQL queries with scalar, table, correlated, EXISTS, LATERAL, common table, recursive, and data-modifying expressions.
Open cheat sheetPostgreSQL Cursors and Batched Fetching Cheat Sheet
Stream PostgreSQL query results safely with cursors, bounded FETCH batches, holdability, row locking, refcursor APIs, and resumable alternatives.
Open cheat sheetPostgreSQL LATERAL Joins and Set-Returning Functions Cheat Sheet
Write PostgreSQL LATERAL and set-returning-function queries for top-N lookups, JSON, arrays, time series, optional expansion, and efficient plans.
Open cheat sheetPostgreSQL NULLs and Conditional Expressions Cheat Sheet
Handle PostgreSQL unknown values with IS NULL, three-valued logic, COALESCE, NULLIF, CASE, comparison predicates, and null-aware ordering.
Open cheat sheetPostgreSQL Recursive Queries and Graph Traversal Cheat Sheet
Build safe PostgreSQL recursive CTEs for hierarchies and graphs with anchors, termination, paths, SEARCH ordering, CYCLE detection, and bounded execution.
Open cheat sheetPostgreSQL Window Functions Cheat Sheet
Analyze PostgreSQL rows with ranking, offsets, partitioned aggregates, explicit frames, named windows, and post-window filtering.
Open cheat sheetSQL Joins Cheat Sheet
Combine related PostgreSQL tables with inner, outer, cross, self, multi-table, aggregate, and lateral joins using clear predicates.
Open cheat sheetSQL SELECT Queries Cheat Sheet
Query, filter, sort, group, join, and compose relational data with practical SQL SELECT examples.
Open cheat sheet