- Overview
- Data types
- Commands
- Functions
- Overview
- Aggregate
- Conditional expression
- Conversion
- Date and time
- Numeric
- String
- Semi-structured data
On this page
variance_samp
Returns the sample variance of non-NULL records in a group. If all records inside a group are NULL, a NULL is returned.
Syntax
variance_samp ( <expr> )Arguments
<expr>
An expression that evaluates to a numeric value. This is the expression on which the variance is calculated.
Returns
The data type of the returned value is float.
If all records inside a group are NULL, this function returns NULL.