diff options
author | Adam Chlipala <adamc@hcoop.net> | 2008-08-28 12:58:11 -0400 |
---|---|---|
committer | Adam Chlipala <adamc@hcoop.net> | 2008-08-28 12:58:11 -0400 |
commit | b3b35a26f843a75330c6536bc9502db679d50abd (patch) | |
tree | 6ac497841faeae4fbb12e7005c5a42f3882bf234 | |
parent | 86b1f463ce9af2ddfcd86bb75279b9809b22db6a (diff) |
Tested aggregate functions with GROUP BY
-rw-r--r-- | tests/agg.lac | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/tests/agg.lac b/tests/agg.lac index f9b744e9..8aa72e6c 100644 --- a/tests/agg.lac +++ b/tests/agg.lac @@ -5,3 +5,6 @@ val q1 = (SELECT COUNT( * ) AS X FROM t1) val q2 = (SELECT AVG(t1.A) AS X FROM t1) val q3 = (SELECT SUM(t1.C) AS X FROM t1) val q4 = (SELECT MIN(t1.B) AS X, MAX(t1.A) AS Y FROM t1) + +(*val q5 = (SELECT t1.A FROM t1 GROUP BY t1.B)*) +val q5 = (SELECT SUM(t1.A) AS X FROM t1 GROUP BY t1.B) |