diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-03-24 22:52:46 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-03-24 22:52:46 +0200 |
| commit | 8c36b3b4ec667c8bf8e9b331e2ab7b83c30d6eb2 (patch) | |
| tree | 7390f1326facb58897c2b70cd6bcbc46949301f1 /mysql-test/r/having.result | |
| parent | 4b1a877b235775717afc0bb114bf5cc7bee0823f (diff) | |
| download | mariadb-git-8c36b3b4ec667c8bf8e9b331e2ab7b83c30d6eb2.tar.gz | |
A fix for bug #176
code cleanup
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index a33ce457176..f113eb6ed49 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -63,3 +63,10 @@ Fld1 max(Fld2) 1 20 3 50 drop table t1; +create table t1 (id int not null, qty int not null); +insert into t1 values (1,2),(1,3),(2,4),(2,5); +select id, sum(qty) as sqty from t1 group by id having sqty>2; +id sqty +1 5 +2 9 +drop table t1; |