comparison tests/agg.lac @ 237:9182068c9d7c

Tested aggregate functions with GROUP BY
author Adam Chlipala <adamc@hcoop.net>
date Thu, 28 Aug 2008 12:58:11 -0400
parents f5732dc1316c
children
comparison
equal deleted inserted replaced
236:f5732dc1316c 237:9182068c9d7c
3 3
4 val q1 = (SELECT COUNT( * ) AS X FROM t1) 4 val q1 = (SELECT COUNT( * ) AS X FROM t1)
5 val q2 = (SELECT AVG(t1.A) AS X FROM t1) 5 val q2 = (SELECT AVG(t1.A) AS X FROM t1)
6 val q3 = (SELECT SUM(t1.C) AS X FROM t1) 6 val q3 = (SELECT SUM(t1.C) AS X FROM t1)
7 val q4 = (SELECT MIN(t1.B) AS X, MAX(t1.A) AS Y FROM t1) 7 val q4 = (SELECT MIN(t1.B) AS X, MAX(t1.A) AS Y FROM t1)
8
9 (*val q5 = (SELECT t1.A FROM t1 GROUP BY t1.B)*)
10 val q5 = (SELECT SUM(t1.A) AS X FROM t1 GROUP BY t1.B)