Product Solutions Support
Try MemSQL

VARIANCE

Aggregate function. Calculates the population variance value from a set of numbers. VARIANCE has synonym VAR_POP which is equivalent. VARIANCE returns NULL if there are not matching rows.

VARIANCE ( expression )

Arguments

Return Type

A double.

Examples

memsql> select VARIANCE(table_rows) from information_schema.tables;
+-----------------+
| std(table_rows) |
+-----------------+
|       2.1500    |
+-----------------+
1 row in set (2.87 sec)
Was this article useful?