What are Aggregate functions in SQL
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 are as follows:
1) Count()
2) Sum()
3) Avg()
4) Min()
5) Max()
Count():
Count(*): Returns total number of records .i.e 6.Count(salary): Return number of Non...
0 Comments
0 Shares