Aggregate Functions

• SUM ([DISTINCT] expr)
  • The total sum of values in expression

• AVG ([DISTINCT] expr)
  • The average of values in the expression

• COUNT ([DISTINCT] expr)
  • The number of non-null values in the expression

• MAX (expr)
  • The highest value in the expression

• MIN (expr)
  • The lowest value in the expression

Previous slide

Next slide

Back to first slide

View graphic version