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