Aggregates and GROUP BY - PostgreSQL for Developers
Aggregates and GROUP BY - part of PostgreSQL for Developers.
PostgreSQL from the inside out - fundamentals through internals and ops.
In this lesson:
Every non-aggregated SELECT column must appear in GROUP BY — Postgres errors if not, but check MySQL-ported code carefully
HAVING belongs after GROUP BY and references aggregates; if the condition references a plain column with no aggregate, it probably belongs in WHERE
COUNT(*) counts all rows including NULLs; COUNT(col) counts only non-NULL values — verify the intent matches the column chosen
Chapters:
0:00 Intro
0:13 What Aggregates and GROUP BY Do
0:27 Walkthrough
0:41 Walkthrough
0:59 Under the Hood: Rows In, Groups Out
1:16 Live Example: Revenue by Customer
1:39 Review Lens: Non-Aggregated Column Missing from GROUP BY
1:57 Recap
Module: SQL Fundamentals
Every command and code example in this video is executed and verified before publishing.
Nesta página do site você pode assistir ao vídeo on-line Aggregates and GROUP BY - PostgreSQL for Developers duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário The Software Mentor 02 Julho 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 5 vezes e gostou 0 espectadores. Boa visualização!
