Previous Topic: Column FunctionsNext Topic: Rules for Column Functions


Description

AVG

Specifies to return the average of the values in the column or expression. The values must be numeric.

SUM

Specifies to return the sum of the values in the column or expression. The values must be numeric.

MAX

Specifies to return the largest value in the column or expression.

MIN

Specifies to return the smallest value in the column or expression.

ALL

Specifies that duplicate values are not to be eliminated before the column function is applied. ALL is the default.

expression

Enter the expression which is to be the argument of the column function. An expression in a column function must include a column name (see the following rules). For more information about expressions, see Expressions.

DISTINCT

Specifies that duplicate values are to be eliminated before the column function is applied.

column-name

Specifies the column which is the argument of the column function.

COUNT(*)

Specifies to count all rows in the result table without eliminating duplicates.

COUNT(DISTINCT column-name)

Specifies to return the number of distinct values of the named column.