Returns the arithmetic mean (average) of the non-null or nonmissing arguments.
| Category: | Descriptive Statistics |
| Returned data type: | DOUBLE |
specifies any valid expression that evaluates to a numeric value.
| Requirement | At least one non-null or nonmissing argument is required. Otherwise, the function returns a null or missing value. |
| Data type | DOUBLE |
| See | <sql-expression> |
| FedSQL Expressions |
|
Statements
|
Results
|
|---|---|
select mean(2,.,.,6); |
4 |
select mean(1,2,3,2); |
2 |