Lines Matching refs:GROUP
14 # GROUP BY and HAVING clauses of SELECT statements.
42 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY y}
45 execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY count(*), y}
48 execsql {SELECT count(*), y FROM t1 GROUP BY y ORDER BY count(*), y}
51 # Some error messages associated with aggregates and GROUP BY
55 SELECT y, count(*) FROM t1 GROUP BY z ORDER BY y
61 SELECT y, count(*) FROM t1 GROUP BY z(y) ORDER BY y
67 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<3 ORDER BY y
73 SELECT y, count(*) FROM t1 GROUP BY y HAVING z(y)<3 ORDER BY y
79 SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<z ORDER BY y
88 SELECT x, count(*), avg(y) FROM t1 GROUP BY x HAVING x<4 ORDER BY x