VeloDB Cloud
SQL Manual
Functions
aggregate-functions
STDDEV,STDDEV_POP

STDDEV,STDDEV_POP

Description

Syntax:

stddev (expl)

This function returns the standard deviation of expr.

Example

MySQL > select stddev(scan_rows) from log_statis group by datetime;
+---------------------+
| stddev(`scan_rows`) |
+---------------------+
|  2.3736656687790934 |
+---------------------+

MySQL > select stddev_pop(scan_rows) from log_statis group by datetime;
+-------------------------+
| stddev_pop(`scan_rows`) |
+-------------------------+
|      2.3722760595994914 |
+-------------------------+

Keywords

STDDEV,STDDEV_POP,POP