MySQL Aggregate Functions

MySQL Aggregate Functions:

MySQL has many built-in functions that you can use in SQL statements for performing calculations on combinations of values in databases; these are called aggregate functions. They include such types of basic statistical analysis as counting rows, determining the average of a given column’s value, finding the maximum and minimum value, and so forth.

Sample Table:

(1) COUNT( )- Returns the number of rows in a database table.

(2) SUM( )- Returns the total sum of a numeric column.

(3) AVG( )- Calculates the average of a set of values.

(4) MIN( )- Returns the lowest value (minimum) in a set of non-NULL values.

(5) MAX( )- Returns the greatest value (maximum) in a set of non-NULL values.