MAX, MEDIAN and MIN Functions
MAX
This function calculates the maximum value (highest numeric value) of the rows satisfying the numeric expression argument.
Syntax
MAX(numExpr)
Where:
numExpr is any expression that evaluates to a numeric value.
The MAX function resets its values for each group in the query according to specific rules.
MEDIAN
This function calculates the median (middle) value of the rows satisfying the numeric expression argument. When
there are an even number of rows, the median is the mean of the two middle rows. This function always returns a double.
Syntax
MEDIAN(numExpr)
Where:
numExpr is any expression that evaluates to a numeric value.
The MEDIAN function resets its values for each group in the query according to specific rules.
MIN
This function calculates the minimum value (lowest numeric value) of the rows satisfying the numeric expression argument.
Syntax
MIN(numExpr)
Where:
numExpr is any expression that evaluates to a numeric value.
The MIN function resets its values for each group in the query according to specific rules
No comments:
Post a Comment