Aggregate Functions in MySQL

Question

Hi!!

Can someone tell me the various aggregate functions and their syntax in MySQL?

Answer 1

The aggregate functions are as follows:

MIN() Function

This function returns the smallest value of the selected column in a table.

Syntax:

SELECT MIN(column_name)
FROMtable_name
WHEREcondition;

MAX() Function

This function returns the largest value of the selected column in a table.

Syntax:

SELECT MAX(column_name)
FROM table_name
WHERE condition;

COUNT() Function

This function returns the number of rows that match the specified criteria.

Syntax:

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

AVG() Function

This function returns the average value of a numeric column that you choose.

Syntax:

SELECT AVG(column_name)
FROM table_name
WHERE condition;

SUM() Function

This function returns the total sum of a numeric column that you choose.

Syntax:

SELECT SUM(column_name)
FROM table_name
WHERE condition;