VARIANCE,VAR_POP,VARIANCE_POP
VARIANCE,VAR_POP,VARIANCE_POPβ
Descriptionβ
Syntaxβ
VARIANCE(expr)
Returns the variance of the expr expression
exampleβ
MySQL > select variance(scan_rows) from log_statis group by datetime;
+-----------------------+
| variance(`scan_rows`) |
+-----------------------+
| 5.6183332881176211 |
+-----------------------+
MySQL > select var_pop(scan_rows) from log_statis group by datetime;
+----------------------+
| var_pop(`scan_rows`) |
+----------------------+
| 5.6230744719006163 |
+----------------------+
keywordsβ
VARIANCE,VAR_POP,VARIANCE_POP,VAR,POP