Aggregate Functions In DBMS

Aggregate Functions In DBMS: The aggregate function is also required in many database applications for generating reports. SQL provides this feature also. SQL provides built-in aggregate functions that are mostly used to generate summary reports. The aggregate functions operate rows of table group-wise and give one result per group.

Functions are very powerful feature of SQL. A function may accept argument as input and returns a value as output. An argument may be a constraint value, variable name, column name or expression.

Aggregate functions have following function.

  1. COUNT
  2. SUM
  3. AVG
  4. MAX
  5. MIN