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.
Comments (No)