On Wed, Nov 10, 2010 at 03:15:35PM -0700, Drake Wilson scratched on the wall:
> The observed useful behavior is to have such a reference return the > value from the first row in each group, I haven't verified this since 3.6.23.1, but in that version the *last* row is the one that is returned. This is true of both ungrouped columns as well as grouped columns (which may not have identical values in each row). Of course "last" is up to the database, not your query, since there is no enforced ordering. > and then to allow control of within-group ordering using ORDER BY. ORDER BY is applied after the GROUP BY and should not have any meaning to the rows within a group. Any change is likely a side-effect. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users