Aggregate

Reference

Syntax

... { MAX( [DISTINCT] col )
    | MIN( [DISTINCT] col )
    | AVG( [DISTINCT] col )
    | SUM( [DISTINCT] col )
    | COUNT( DISTINCT col )
    | COUNT( * )
    | count(*) } ... .

Effect

Aggregate expressions in the SELECT statement.

Additions

• MAX( [DISTINCT] col )
  Maximum total of the values in the column col.
  
  
• MIN( [DISTINCT] col )
  Minimum total of the values in the column col.
  
  
• AVG( [DISTINCT] col )
  Average total of the values in the column col.
  
  
• SUM( [DISTINCT] col )
  Total of the values in the column col.
  
  
• COUNT( DISTINCT col )
  Number of different values in the column col.
  
  
• COUNT( * ), count(*)
  Number of lines in the result quantity.