Ludovic VP <ludovi...@hotmail.com> wrote: > REF: > http://stackoverflow.com/questions/10171403/why-does-select-results-differ-between-mysql-and-sqlite > Consider these statements: > create table foo (id INT, score INT); > insert into foo values (106, 4);insert into foo values (107, 3);insert into > foo values (106, 5);insert into foo values (107, 5); > select T1.id, avg(T1.score) avg1from foo T1group by T1.idhaving not exists ( > select T2.id, avg(T2.score) avg2 from foo T2 group > by T2.id having avg2> avg1); > > The select statement returns:id avg1 ---------- ----------106 4.5 107 4.0 > Shouldn't it return:id avg1 ---------- ----------106 4.5 > instead?
Looks like a bug to me, for what it's worth. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
