Aggregate function are sum(),count(),avg(),max(),min()

count() function in MYSQL

count() function counts the number of record in table

Read More →

Sum() function in MYSQL

Sum() function return the addition of all number of column data

Read More →

avg() function in MYSQL

avg() function find the average of the record value

Read More →

avg() function in MYSQL

avg() function find the average of the record value

Read More →

MIN() function in MYSQL

MIN() function return the record with minimum data value

Read More →

MAX() function in MYSQL

MAX() function return the record with max data value

Read More →

First function in MYSQL

First or LIMIT we use to fetch some starting record of the table

Read More →

last function in MYSQL

ORDER BY in decreasing order with LIMIT is return the last row of the table

Read More →
Aggregate Functions,count() function in MYSQL,Sum() function in MYSQL,avg() function in MYSQL,avg() function in MYSQL,MIN() function in MYSQL,MAX() function in MYSQL,First function in MYSQL,last function in MYSQL