Lines Matching refs:GROUP

16 # GROUP BY and HAVING clauses of SELECT statements.
55 # Try some basic GROUP BY clauses
58   execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61   execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64   execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67   execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
70   execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
73   execsql {SELECT log*2+1, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
77     SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
82     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
87     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
92     SELECT log, count(*) FROM t1 GROUP BY 'x' ORDER BY log;
94 } {1 {GROUP BY terms must not be non-integer constants}}
97     SELECT log, count(*) FROM t1 GROUP BY 0 ORDER BY log;
99 } {1 {GROUP BY column number 0 out of range - should be between 1 and 2}}
102     SELECT log, count(*) FROM t1 GROUP BY 3 ORDER BY log;
104 } {1 {GROUP BY column number 3 out of range - should be between 1 and 2}}
107     SELECT log, count(*) FROM t1 GROUP BY 1 ORDER BY log;
112 #    SELECT log, count(*) FROM t1 GROUP BY 2 ORDER BY log;
117 #    SELECT log, count(*) FROM t1 GROUP BY count(*) ORDER BY log;
121 # Cannot have a HAVING without a GROUP BY
126 } {1 {a GROUP BY clause is required before HAVING}}
131   execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
136     GROUP BY log 
144     GROUP BY log 
152     GROUP BY x
160     GROUP BY x
169     GROUP BY log 
176     GROUP BY log 
181 # Test sorting of GROUP BY results in the presence of an index
182 # on the GROUP BY column.
186     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
191     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
196     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
201     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
207     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
212     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
217     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
222     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;