# What are SQL Aggregate functions and how to apply them?

## In SQL an aggregate function is a function in which values of multiple rows are grouped together to form a single value of more significant measurement such as a set or a list etc

Do you have similar website/ Product?

Show in this page just for
$5 (for a month)

0/60

0/180

1.The COUNT() function returns the number of rows that matches a specified criteria.

**Syntax of COUNT()**

*SELECT COUNT(column_name)*

*FROM table_name*

*WHERE condition;*

2. The AVG() function returns the average value of a numeric column.

**Syntax of AVG()**

*SELECT AVG(column_name)*

*FROM table_name*

*WHERE condition;*

3.The SUM() function returns the total sum of a numeric column.

**Syntax of SUM()**

*SELECT SUM(column_name)*

*FROM table_name*

*WHERE condition;*

4.The MIN() function returns the smallest value of the selected column.

**Syntax of MIN()**

*SELECT MIN(column_name)*

*FROM table_name*

*WHERE condition;*

5. The MAX() function returns the largest value of the selected column.

**Syntax of MAX()**

*SELECT MAX(column_name)*

*FROM table_name*

*WHERE condition;*

6.The FIRST() function returns the first value of the selected column.

**Syntax of FIRST()**

*SELECT FIRST(column_name)*

*FROM table_name;*

*WHERE condition;*

6.The LAST() function returns the last value of the selected column. It can be used only in MS ACCESS.

**Syntax of LAST()**

SELECT LAST(column_name)

FROM table_name;

WHERE condition;

CONTINUE READING

SQL Aggregate functions

Ayesha

Tech writer at newsandstory