Hi,
Thanks to everyone who helped with this!
I'll try some stuff out and see if I can get things efficient, fast *and*
simple.
:-)
"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."
--
Best wishes,
@ndy
--
andy...@ashurst.eu.org
http://www.ashurst.eu.org/
0x7EBA75FF
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
