SingleStore DB

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)