STDDEV_POP

函数说明

STDDEV_POP(expr) 是一个聚合函数，计算总体标准差。

函数语法

1. > STDDEV_POP(expr)

参数释义

示例

1. > CREATE TABLE t1(PlayerName VARCHAR(100) NOT NULL,RunScored INT NOT NULL,WicketsTaken INT NOT NULL);
2. > INSERT INTO t1 VALUES('KL Rahul', 52, 0 ),('Hardik Pandya', 30, 1 ),('Ravindra Jadeja', 18, 2 ),('Washington Sundar', 10, 1),('D Chahar', 11, 2 ),  ('Mitchell Starc', 0, 3);
3. > SELECT STDDEV_POP(RunScored) as Pop_Standard_Deviation FROM t1;
4. > SELECT  STDDEV_POP(WicketsTaken) as Pop_Std_Dev_Wickets FROM t1;

7. > SELECT STDDEV_POP(RunScored) as Pop_Standard_Deviation FROM t1;
8. +------------------------+
9. | Pop_Standard_Deviation |
10. +------------------------+
11. |                16.8762 |
12. +------------------------+
13. 1 row in set (0.02 sec)

15. > SELECT  STDDEV_POP(WicketsTaken) as Pop_Std_Dev_Wickets FROM t1;
16. +---------------------+
17. | Pop_Std_Dev_Wickets |
18. +---------------------+
19. |              0.9574 |
20. +---------------------+
21. 1 row in set (0.01 sec)