Lines Matching refs:GROUP

16 # GROUP BY and HAVING clauses of SELECT statements.
44   execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY y}
47   execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY count(*), y}
50   execsql {SELECT count(*), y FROM t1 GROUP BY y ORDER BY count(*), y}
53 # Some error messages associated with aggregates and GROUP BY
57     SELECT y, count(*) FROM t1 GROUP BY z ORDER BY y
63     SELECT y, count(*) FROM t1 GROUP BY z(y) ORDER BY y
69     SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<3 ORDER BY y
75     SELECT y, count(*) FROM t1 GROUP BY y HAVING z(y)<3 ORDER BY y
81     SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<z ORDER BY y
90     SELECT x, count(*), avg(y) FROM t1 GROUP BY x HAVING x<4 ORDER BY x