github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_aggr.sql (about)

     1  
     2  -- @suite
     3  -- @setup
     4  
     5  -- @case
     6  -- @desc:test for stddev_pop
     7  -- @label:bvt
     8  
     9  drop table if exists t1;
    10  CREATE TABLE t1 (id int(11),value1 float(10,2));
    11  INSERT INTO t1 VALUES (1,0.00),(1,1.00), (1,2.00), (2,10.00), (2,11.00), (2,12.00), (2,13.00);
    12  select id, stddev_pop(value1)  from t1 group by id;
    13  select id, variance(value1)  from t1 group by id;
    14  drop table t1;
    15  
    16  drop table if exists t;
    17  CREATE TABLE t(txt char(1), i INT);
    18  INSERT INTO t VALUES ('a', 2), ('b', 8), ('b', 0), ('c', 2);
    19  SELECT txt, STDDEV_POP(i) s FROM t GROUP BY txt ORDER BY s, txt;
    20  drop table t;
    21  
    22