Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

SQL Aggregation and Window Functions Cheat Sheet

A 2-page reference for GROUP BY and window functions: 15 short entries with copy-ready code.

ForDevelopers

sql-aggregation-and-window-functions-cheat-sheet.pdfShowing 18 of 72 lines
// Basic aggregates
SELECT count(*), sum(total), avg(total), min(total), max(total)
FROM orders;

// GROUP BY
SELECT status, count(*) AS n
FROM orders
GROUP BY status;

// HAVING
SELECT user_id, sum(total) AS spent
FROM orders
GROUP BY user_id
HAVING sum(total) > 1000;

// Count distinct
SELECT count(DISTINCT user_id) FROM orders;

What's inside

Format
PDF, Markdown
Contents
15 sections · 2 pages
Version
1.0 · Updated 3 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • sql-aggregation-and-window-functions-cheat-sheet.pdfPDF · 21 KB
  • sql-aggregation-and-window-functions-cheat-sheet.mdMarkdown · 2 KB
  • LICENSE.txtadded to every download

About this item

A compact, printable reference for GROUP BY and window functions. Each of the 15 entries has a one-line explanation and a small example you can paste into your editor. The PDF uses a two-column A4 layout designed to sit next to your keyboard, and the same content ships as Markdown so you can search it or drop it into your notes. Every SQL example targets ANSI SQL / PostgreSQL.

  • SQL
  • Analytics
  • Window functions
  • Aggregation
  • Cheat sheet

Reviews

No reviews yet.

You might also grab