View Categories

What are aggregate functions in SQL?

Parthiban Kannan
Updated on December 2, 2025

1 min read

Aggregate functions in SQL are functions that perform calculations on a set of values and return a single summary value. They are commonly used in reporting, analytics, and data summarization, often in combination with the GROUP BY clause.

Common Aggregate Functions: #

  1. COUNT() – Counts the number of rows.
🗃️
filename.sql 
SELECT COUNT(*) AS total_employees
FROM employees;

2. SUM() – Adds up numeric values in a column.

🗃️
filename.sql 
SELECT SUM(salary) AS total_salary
FROM employees;
  1. AVG() – Calculates the average value of a numeric column.
🗃️
filename.sql 
SELECT AVG(salary) AS average_salary
FROM employees;

4. MAX() – Returns the maximum value in a column.

🗃️
filename.sql 
SELECT MAX(salary) AS highest_salary
FROM employees;

5. MIN() – Returns the minimum value in a column.

🗃️
filename.sql 
SELECT MIN(salary) AS lowest_salary
FROM employees;

Example with GROUP BY:

🗃️
filename.sql 
SELECT department, COUNT(*) AS num_employees, SUM(salary) AS total_salary
FROM employees
GROUP BY department;

This groups employees by department and provides the number of employees and total salary per department.

Real-world scenario: #

I frequently use aggregate functions for sales reporting. For instance, calculating total sales (SUM) per region, counting the number of orders (COUNT) per customer, or finding the highest (MAX) and lowest (MIN) transaction amounts. This helps management make informed decisions.

Challenges: #

  • Handling NULL values: COUNT(column) ignores NULLs, while SUM and AVG also skip NULLs. Forgetting this can lead to unexpected results.
  • Using aggregate functions on very large datasets can affect performance, so indexing or partitioning may be required.

Limitations: #

  • Aggregate functions return a single value per group; they do not return individual row-level data.
  • They need careful use with GROUP BY and HAVING for meaningful results.

Alternative/Enhancement: #

  • For row-level context alongside aggregates, I use window functions like SUM() OVER(PARTITION BY department) to compute totals without collapsing rows.

In summary, aggregate functions are essential for summarizing, analyzing, and reporting data in SQL efficiently. They turn raw data into actionable insights.

Scroll to Top