"There's a small sidenote (that I'm too lazy too find right now) in the select docs that mentions that, in case of using min or max as aggregate, the non-aggregate columns will come from the row that held the min/max value."
Look in https://www.sqlite.org/quirks.html under "6. Aggregate Queries Can Contain Non-Aggregate Result Columns That Are Not In The GROUP BY Clause" and also in https://www.sqlite.org/lang_select.html In section 3 search for: "Side note: Bare columns in an aggregate queries." _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users