Hi, Consider the following exemple : CREATE TABLE t1 ( a TEXT PRIMARY KEY, b INTEGER);
SELECT * FROM t1 GROUP BY a HAVING b > 1;Will the GROUP BY clause be supressed and HAVING clause be rewritten in WHERE clause by the optimizer ?
Jean-Baptiste _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users