www.itechowais.tech


Aggregate Function and its advantages-

 Aggegate function :- In DBMS, Aggregate function is a function where the values of multiple rows are grouped together to form a single summary value.

          e.g – 1. Count()

                     2. Sum()

                     3. Avg()

                     4. Max()

                     5. Min()

        Advantages :-

§  Calculation on a set of values & it returns a single value.

§  Ignore Null values except Count().

§  It is used with the GROUP BY clause of the ‘select’ statement.