Aggregate Function
Aggregate Function Aggregate Function: 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…
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.
- COUNT
- SUM
- AVG
- MAX
- MIN