Summary: in this tutorial, you will learn about the SQL aggregate functions including AVG(), COUNT(), MIN(), MAX(), and SUM(). An SQL aggregate function calculates on a set of values and returns a single value. For example, the average function AVG takes a list of values and returns the average.

The AVG function is an aggregate function that calculates the average value of a set. Here’s the syntax of the AVG function: AVG([ALL|DISTINCT] expression) Code language: SQL (Structured Query Language) (sql) If you use the ALL keyword, the AVG function calculates the average value of all values, including duplicates.

In SQL, the ANY_VALUE aggregate function returns any value from a set of values. Unlike other aggregate functions like MIN or MAX , which returns a specific value, the ANY_VALUE picks one value from a set without guaranteeing which one it returns.

The SQL COUNT function is an aggregate function that returns the number of rows returned by a query. For example, you can use the COUNT function in the SELECT statement to get the number of employees, the number of employees in each department, the number of employees who hold a specific job, etc.

This tutorial introduces you SQL GROUP BY that combines rows into groups and apply aggregate function such as AVG, SUM, COUNT, MIN, MAX to each group.

The SUM function is an aggregate function that returns the sum of all or distinct values. We can apply the SUM function to the numeric column only. The following illustrates the syntax of the SUM function.

In this tutorial, you will learn how to find the maximum value in a group using the SQL MAX aggregate function.

In this tutorial, you will learn about the SQL aggregate functions including AVG(), COUNT(), MIN(), MAX(), and SUM().

This tutorial shows how to use SQL RANK() function to find ranks of rows in a result set. It provides some practical applications of the RANK() function. Skip to content

Aggregate functions – Returns a value such as min, max, average, sum, and count for a set of values. AVG – Returns the average value of a set. COUNT – Returns the number of items in a set.