In this article, we are going to discuss **SQL Aggregate Functions** using practical examples with syntax.

**List Of Aggregate Functions **

Below are the commonly used SQL Aggregate Functions.

**AVG**– Returns the average value for the selected column in the table**COUNT**– Returns the number of rows for the selected column in the table**FIRST**– Returns the first value for the selected column in the table**LAST**– Returns the last value for the selected column in the table**MAX**– Returns the largest value for the selected column in the table**MIN**– Returns the smallest value for the selected column in the table**SUM**– Returns the sum value for the selected column in the table.

Now I am going to use the Employee table to work on these aggregate functions.

**AVG() Function **

Average returns average value of a numeric column

The **Syntax **for this function is as follows

SELECTAVG(column_name)FROMtable_name

### Practical Use Of **AVG** Function

Consider the following Employee Table

SQL Query to find Average Salary as Follows

Select AVG(Salary)FromEmployee;

Result of the above query will be as follows.

**Count() **Function

Here count returns the number of rows present in the employee table either based on some condition or without condition.

The syntax for this function is as follows.

SELECTCount(column_name)FROMtable_name

**Practical Use Of Count Function**

Consider the following Employee Table.

SQL query to count number of employee based on certain condition is as follows.

SELECTCOUNT(Name)FROMEmployeeWHERESalary = 6000.25;

Result of the above query will be

**FIRST() Function **

First function returns first value of a selected column in the table.

Syntax for FIRST function is as follows

SELECTFIRST(column_name) FROM table_name;

Practical Use Of FIRST Function

Practical Use Of FIRST Function

Consider the following employee table

SQL query for this function will be as follows

SELECTFIRST(Salary)FROMEmployee

and the results will be as follows

**LAST() Function**

Last function returns the last value of the selected column in the table.

Syntax for the last function is as follows

Consider the following employee table

SQL Query for this function is as follows

SELECTLAST(Salary)FROMEmployee

Result of the above query will be as follows.

**MAX() Function**

Max function returns the maximum value of the selected column for a particular table.

Syntax for this function is as follows,

SELECTMAX(column_name)FROMtable_name;

Practical use of MAX function is as follows

Consider the following employee table for this function

SQL query to find the maximum salary from the table is as follows.

SELECTMAX(Salary)FROMEmployee

Result of the query will be as follows.

**MIN() Function**

Minimum function returns the minimum value of the selected column in the specific table

Syntax for MIN function is as follows

SELECTMIN(column_name)FROMtable_name

**Practical use of MIN Function **

Consider the following employee table

SQL query to find the minimum salary from the employee table is as follows

SELECTMIN(Salary)FROMEmployee

Results for this query will be as follows

**SUM() Function**

SUM function returns the total sum of selected column for a particular table.

Syntax for this function is as follows

SELECTSUM(table_name) FROM column_name

**Practical use of SUM function is as follows**

Let us consider the following employee table

SQL query to find the SUM of salary from employee table is as follows.

SELECTSUM(Salary)FROMEmployee;

Results for the query will be as follows

I hope this article is useful to you. Please leave your comment in the comment section below. I am happy to answer your questions.

You can read our other related article Date Functions in SQL