diff options
| author | vva@eagle.mysql.r18.ru <> | 2002-12-14 03:36:59 +0400 |
|---|---|---|
| committer | vva@eagle.mysql.r18.ru <> | 2002-12-14 03:36:59 +0400 |
| commit | b624df724b099201c99cfa2db59f95479c413b41 (patch) | |
| tree | aec2e74172b465c0f467414b55fa86e25ab8d550 /mysql-test/r/select.result | |
| parent | 710881e4fbc3a4586507bbf1eb3a85a7adfe0048 (diff) | |
| download | mariadb-git-b624df724b099201c99cfa2db59f95479c413b41.tar.gz | |
add VARIANCE function
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 46343eb8248..37943ec1189 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2656,14 +2656,14 @@ companynr count(*) 58 23 53 4 50 11 -select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1) from t2 where companynr = 34 and fld4<>""; -count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) -70 absentee vest 17788966 254128.0857 3272.5940 -select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1) from t2 group by companynr limit 3; -companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) -00 82 Anthony windmills 10355753 126289.6707 115550.9757 -29 95 abut wetness 14473298 152350.5053 8368.5480 -34 70 absentee vest 17788966 254128.0857 3272.5940 +select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>""; +count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1) +70 absentee vest 17788966 254128.0857 3272.5940 10709871.3069 +select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3; +companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1) +00 82 Anthony windmills 10355753 126289.6707 115550.9757 13352027981.7087 +29 95 abut wetness 14473298 152350.5053 8368.5480 70032594.9026 +34 70 absentee vest 17788966 254128.0857 3272.5940 10709871.3069 select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10; companynr t2nr count(price) sum(price) min(price) max(price) avg(price) 37 1 1 5987435 5987435 5987435 5987435.0000 |