Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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.

Syntax

VARIANCE ( 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 VARIANCE(table_rows) FROM information_schema.tables;
+----------------------+
| VARIANCE(table_rows) |
+----------------------+
|         2.1500       |
+----------------------+
1 row in set (2.87 sec)