This tutorial introduces you to the most commonly used SQL aggregate functions including AVG, COUNT, MAX, MIN and SUM functions.

In this tutorial, you will learn how to use the SQL AVG function to calculate the average value of a set of values.

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 …

In this tutorial, you'll learn how to use the SQL ANY_VALUE () aggregate function to select any value from a group.

In this tutorial, we will introduce you to the SQL SUM function that calculates the sum of values or distinct values in a set.

This tutorial helps you master the SQL MIN function through practical examples. After the tutorial, you will know how to apply the MIN function effectively.

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

The aggregate functions perform calculations across rows and return a single output row. The following query uses the SUM() aggregate function to calculate the total salary of all employees in the company:

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.

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.