VARIANCE,VAR_POP,VARIANCE_POP

Description

Syntax

VARIANCE(expr)

Returns the variance of the expr expression

example

  1. MySQL > select variance(scan_rows) from log_statis group by datetime;
  2. +-----------------------+
  3. | variance(`scan_rows`) |
  4. +-----------------------+
  5. | 5.6183332881176211 |
  6. +-----------------------+
  7. MySQL > select var_pop(scan_rows) from log_statis group by datetime;
  8. +----------------------+
  9. | var_pop(`scan_rows`) |
  10. +----------------------+
  11. | 5.6230744719006163 |
  12. +----------------------+

keyword

VARIANCE,VAR_POP,VARIANCE_POP,VAR,POP