Aggregate Functions
Five standard functions: COUNT, SUM, MIN, MAX, AVG
Normally appears in SELECT clause
SELECT SUM (SALARY)
Is applied after WHERE
Result is a column in the output
can sometimes think of as a scalar
Previous slide
Next slide
Back to first slide
View graphic version