STDDEV,STDDEV_POP

Description

Syntax

stddev (expl)

Returns the standard deviation of the expr expression

example

  1. MySQL > select stddev(scan_rows) from log_statis group by datetime;
  2. +---------------------+
  3. | stddev(`scan_rows`) |
  4. +---------------------+
  5. | 2.3736656687790934 |
  6. +---------------------+
  7. MySQL > select stddev_pop(scan_rows) from log_statis group by datetime;
  8. +-------------------------+
  9. | stddev_pop(`scan_rows`) |
  10. +-------------------------+
  11. | 2.3722760595994914 |
  12. +-------------------------+

keyword STDDEV,STDDEV_POP,POP