SQLaggregatesCOUNTSUM
What are COUNT, SUM, AVG, MIN, MAX in SQL? Aggregate functions for beginners
Aggregate functions are tools for "computing something across a group of rows". COUNT — how many rows, SUM — total, AVG — average, MIN/MAX — smallest and largest. Plain words: the difference between COUNT(*) and COUNT(column), how NULL affects aggregates, common scenarios, and pitfalls.
1 min de cititSQL · aggregates · COUNT · SUM · tutorial
Exersează pe probleme reale
Rezolvă probleme în antrenorul SQL cu notare instantanee și indicii.
Deschide antrenorul
These are the five most basic aggregate functions. They answer "how many", "how much in total", "average", "smallest", "largest" by collapsing a group of rows into a single number.
This article is currently in Russian. The full English translation is on the way.