Thursday, July 17, 2014

Aggregate Functions in MySQL

Aggregate Functions are those functions which are used in SQL. They return a single value which is calculated from values in the columns from a particular table.

The aggregate functions are below:

AVG()- It returns a average value
COUNT() - It returns the number of rows in a table
MAX() - It returns the maximum value stored in a table
MIN() - It returns the minimum value stored in a table
SUM() - It returns the sum of all the values of specified column