Aggregatfunktionen (EN)

Aggregatfunktionen

Aggregate functions in SQL are special functions that process multiple values from one or more columns into a single, summarized value. The most common aggregate functions include COUNT for counting rows, SUM for adding numeric values, AVG for calculating the average, MIN for finding the smallest value, and MAX for finding the largest value. These functions are often used in combination with the GROUP BY clause to divide data into groups and calculate an aggregated value for each group. Aggregate functions are a powerful tool for data analysis and reporting in databases.

Im Kontext

• Typically used together with GROUP BY, HAVING and ORDER BY
• Related to: Window functions, Subqueries, CTEs
• Example use: Calculation of sales per product category, average grade per class