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/having.result | |
| parent | 710881e4fbc3a4586507bbf1eb3a85a7adfe0048 (diff) | |
| download | mariadb-git-b624df724b099201c99cfa2db59f95479c413b41.tar.gz | |
add VARIANCE function
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index a33ce457176..bd1bd523964 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -62,4 +62,8 @@ select Fld1, max(Fld2) from t1 group by Fld1 having std(Fld2) is not null; Fld1 max(Fld2) 1 20 3 50 +select Fld1, max(Fld2) from t1 group by Fld1 having variance(Fld2) is not null; +Fld1 max(Fld2) +1 20 +3 50 drop table t1; |