VARIANCE

函数说明

VAR(expr)是一个聚合函数，计算总体方差。

函数语法

  1. > VAR(expr)

参数释义

参数说明
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 VAR(RunScored) as Pop_Standard_Variance FROM t1;
  4. > SELECT VAR(WicketsTaken) as Pop_Std_Var_Wickets FROM t1;
  7. > SELECT VAR(RunScored) as Pop_Standard_Deviation FROM t1;
  8. +------------------------+
  9. | Pop_Standard_Deviation |
  10. +------------------------+
  11. |               284.8056 |
  12. +------------------------+
  13. 1 row in set (0.04 sec)
  15. > SELECT VAR(WicketsTaken) as Pop_Std_Var_Wickets FROM t1;
  16. +---------------------+
  17. | Pop_Std_Var_Wickets |
  18. +---------------------+
  19. |              0.9167 |
  20. +---------------------+
  21. 1 row in set (0.04 sec)

限制

MatrixOne目前只支持在查询表的时候使用函数，不支持单独使用函数。