---
title: "Provide examples of common SQL aggregate functions and their use cases."  
description: "Provide examples of common SQL aggregate functions and their use cases."  
author: "Steilla Mitchel"  
published: 2023-09-04  
updated: 2023-09-26  
canonical: https://www.mindstick.com/forum/159815/provide-examples-of-common-sql-aggregate-functions-and-their-use-cases  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# Provide examples of common SQL aggregate functions and their use cases.

Provide examples of [common SQL](https://www.mindstick.com/forum/159829/provide-examples-of-common-sql-window-functions-and-their-use-cases) [aggregate functions](https://www.mindstick.com/forum/158949/what-are-the-conditional-aggregate-functions-in-sql-such-as-sum-case-and-how-are-they-used) and their use cases.

## Replies

### Reply by Aryan Kumar

Certainly! Here are some [common](https://www.mindstick.com/articles/23170/10-most-common-accounting-mistakes-of-small-business) [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [aggregate](https://www.mindstick.com/blog/52/aggregate-functions-in-database) [functions](https://www.mindstick.com/forum/160140/explain-the-role-of-functions-as-a-service-faas-in-serverless-computing) and their typical use cases:

**COUNT()**:

- Use Case: Count the number of rows in a table or the number of rows that meet a specific condition.

```plaintext
SELECT COUNT(*) FROM employees;
```

**SUM()**:

- Use Case: Calculate the sum of values in a numeric column.

```plaintext
SELECT SUM(salary) FROM sales;
```

**AVG()**:

- Use Case: Calculate the average value of a numeric column.

```plaintext
SELECT AVG(rating) FROM product_reviews;
```

**MAX()**:

- Use Case: Find the maximum value in a column, often used to find the highest value.

```plaintext
SELECT MAX(price) FROM products;
```

**MIN()**:

- Use Case: Find the minimum value in a column, often used to find the lowest value.

```plaintext
SELECT MIN(stock_quantity) FROM inventory;
```

**GROUP_CONCAT()** (or equivalent functions like **STRING_AGG()** in SQL Server, **LISTAGG()** in Oracle):

- Use Case: Concatenate values from multiple rows into a single string, useful for creating comma-separated lists.

```plaintext
SELECT department, GROUP_CONCAT(employee_name) AS employee_list
FROM employees
GROUP BY department;
```

**SUM() with GROUP BY**:

- Use Case: Calculate the sum of values within groups, often used for group-level aggregations.

```plaintext
SELECT department, SUM(sales_amount) AS total_sales
FROM sales
GROUP BY department;
```

**AVG() with HAVING**:

- Use Case: Calculate the average of a numeric column for groups and filter the results using the HAVING clause.

```plaintext
SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department
HAVING AVG(salary) > 50000;
```

**COUNT() with DISTINCT**:

- Use Case: Count the number of distinct values in a column, excluding duplicates.

```plaintext
SELECT COUNT(DISTINCT product_category) FROM products;
```

**COUNT() with CASE**:

- Use Case: Count rows that meet specific conditions using a CASE statement within COUNT.

```plaintext
SELECT COUNT(CASE WHEN status = 'Completed' THEN 1 ELSE NULL END) AS completed_orders
FROM orders;
```

These aggregate functions are fundamental in SQL and are used extensively for summarizing and analyzing data in databases. Depending on your specific data analysis needs, you can choose the appropriate aggregate function to retrieve the desired information from your database tables.


---

Original Source: https://www.mindstick.com/forum/159815/provide-examples-of-common-sql-aggregate-functions-and-their-use-cases

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.