Open In App
Related Articles

Aggregate functions in SQL

Improve Article
Save Article
Like Article

In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning.


Various Aggregate Functions

1) Count()
2) Sum()
3) Avg()
4) Min()
5) Max()


Now let us understand each Aggregate function with a example:

Id     Name     Salary
1       A        80
2       B        40
3       C        60
4       D        70
5       E        60
6       F        Null




Count(*): Returns total number of records .i.e 6.
Count(salary): Return number of Non Null values over the column salary. i.e 5.
Count(Distinct Salary):  Return number of distinct Non Null values over the column salary .i.e 4




sum(salary):  Sum all Non Null values of Column salary i.e., 310
sum(Distinct salary): Sum of all distinct Non-Null values i.e., 250.




Avg(salary) = Sum(salary) / count(salary) = 310/5
Avg(Distinct salary) = sum(Distinct salary) / Count(Distinct Salary) = 250/4




Min(salary): Minimum value in the salary column except NULL i.e., 40.
Max(salary): Maximum value in the salary i.e., 80.


Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above

Unlock the Power of Placement Preparation!
Feeling lost in OS, DBMS, CN, SQL, and DSA chaos? Our Complete Interview Preparation Course is the ultimate guide to conquer placements. Trusted by over 100,000+ geeks, this course is your roadmap to interview triumph.
Ready to dive in? Explore our Free Demo Content and join our Complete Interview Preparation course.

Last Updated : 20 Aug, 2019
Like Article
Save Article
Similar Reads