What are aggregate functions in SQL?

< 1 min read

Aggregate functions perform calculations on multiple rows and return a single value.
Common examples are SUM, COUNT, AVG, MIN, and MAX.
They are used to generate summaries instead of detailed data.
In my project, we used SUM for revenue and COUNT for order volume.
Aggregate functions are usually combined with GROUP BY.
They help answer business questions at a higher level.
These functions are core to analytical and reporting queries.

Power BI Essentials