What are the different aggregate function in the SQL?

[bharti_rajpal]

Hi,


Please let me know What are the different aggregate function in the SQL? Actually I recently started the SQL course. So I just want to aware about aggregate function.

If you know any aggregate function then please share with me.
Your help will be greatly appreciated.

[MindSpace]

Hi,

I also studying the SQL, below are some aggregate functions of the SQL which are I know:

1. Max : Used to find out the maximum among the column values

2. Avg : Used to calculate the average value o the column

3. Count : Used to count the total column value

4. Sum : Used to find out the sum of the column values

5. Min : Used to find out the minimum among the column values

[Modifier]

Hi friends,

Following are some SQL queries which will explain you the use of the different aggregate functions:

*. Select sum(mark) from student.

*. Select avg(mark) from student.

*. Select count(stud_name) from student.

*. Select min(percentage) from student.

*. Select max(percentage) from student.


Please try these queries.

[Praetor]

Hi,

Aggregate function plays very important role in the complicate SQL transactions.

Using different aggregate functions you are able do the transaction such as find out the max or min value from the entire table, or to calculate the sum of the values from table. sum(), min(), count(),avg() are some available aggregate functions in the SQL.