Hi, 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? I'm using 3.7.7.1 Kindly, Ludovic Vaugeois-Pepin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users