Skip to main content

Posts

Showing posts from 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