SelectDB Cloud
SQL 手册
SQL 函数
聚合函数
STDDEV,STDDEV_POP

STDDEV,STDDEV_POP

description

Syntax

STDDEV(expr)

返回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

© 2023 北京飞轮数据科技有限公司 京ICP备2022004029号 | Apache、Apache Doris 以及相关开源项目名称均为 Apache 基金会商标