VAR_SAMP
Aggregate function. Calculates the sample variance value from a set of numbers. VAR_SAMP
returns NULL if there are not matching rows.
Syntax
VAR_SAMP ( expression )
Arguments
expression: any expression. This may be a column name, the result of another function, or a math operation.
Return Type
A double.
Examples
SELECT VAR_SAMP(table_rows) FROM information_schema.tables; +----------------------+ | VAR_SAMP(table_rows) | +----------------------+ | 2.1500 | +----------------------+ 1 row in set (2.87 sec)