Aggregate Functions
Aggregate functions are used to perform some computation against group of values. Each field in a table can be thought of as one group of values. Use of the GROUP BY clause in a select statement allows the creation of multiple value groups.
Function Name Designer Esc Proc Comments
COUNT( Any | * ) YES YES Returns the count of not null entries in a column or when used with * the count of records.
MIN(d) YES YES Returns the smallest value in a group.
MAX(d) YES YES Returns the largest value in a group.
SUM(d) YES YES Adds all values in a group together.
AVG(d) YES YES Returns the average for the group of values.
SOME(b) NO NO Returns TRUE if any value in a group = TRUE
EVERY(b) YES YES Returns TRUE only if all values in a group = TRUE.
Aggregate Functions
Aggregate functions are used to perform some computation against group of values. Each field in a table can be thought of as one group of values. Use of the GROUP BY clause in a select statement allows the creation of multiple value groups.
Function Name Designer Esc Proc Comments
COUNT( Any | * ) YES YES Returns the count of not null entries in a column or when used with * the count of records.
MIN(d) YES YES Returns the smallest value in a group.
MAX(d) YES YES Returns the largest value in a group.
SUM(d) YES YES Adds all values in a group together.
AVG(d) YES YES Returns the average for the group of values.
SOME(b) NO NO Returns TRUE if any value in a group = TRUE
EVERY(b) YES YES Returns TRUE only if all values in a group = TRUE.