Aggregate Functions

Table of Contents



Aggregate functions are used to evaluate multiple rows when collapsing a group of documents as dictated by a Group By clause.

  • Avg - Computes the average value of a numeric field within a specified schema.
  • Count - Tallies the occurrences of a specific field within a given schema.
  • Max - Computes the maximum value of a numeric field within a specified schema.
  • Min - Computes the minimum value of a numeric field within a specified schema
  • Security Policy - Policy DDL is used to create accounts, roles and manage memberships.
  • Sum - Computes the total or summation value of a numeric field within a specified schema


Home
The home page
SQL :: Avg
Computes the average value of a numeric field within a specified schema.
SQL :: Count
Tallies the occurrences of a specific field within a given schema.
SQL :: Group By
Group by allows you to select a result set and collapse it by a set of given fields.
SQL :: Max
Computes the maximum value of a numeric field within a specified schema.
SQL :: Min
Computes the minimum value of a numeric field within a specified schema
SQL :: Sum
Computes the total or summation value of a numeric field within a specified schema
SQL::Keywords
A breakdown of all high-level statements available via the query handler.