| Aggregate functions helps to perform operation on a set of values from database or on another values and return a single value. All the aggregate functions ignore NULL values except one COUNT function.To filter on aggregate functions result we have to used having clause with GROUP BY. Here are the some example of aggregate functions:
AVG, MIN, CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX, VARP etc. | | |