On Tue, Jan 14, 2020 at 2:57 PM Jean-Baptiste Gardette <jb.garde...@orens.fr> wrote: > 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 ?
My question would be why you wouldn't write it as a WHERE clause in the first place :) Sorry, OT, I know. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
