On Thu, May 24, 2012 at 1:22 PM, Mike King <mkwi...@gmail.com> wrote: > Is this Select statement valid? In Oracle, it wouldn't be because > what is the aggregate of A. Is this behavior defined anywhere? > > create table T (A,B); > insert into T (A,B) values (1,3); > insert into T (A,B) values (2,3); > > select A,B > from T > group by B;
For SQLite this statement is valid but behavior is undefined - you can get either 1 or 2 for A without any determinism. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users