The last one it saw. It's not deterministic.
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Ralf Junker > Sent: Friday, May 04, 2012 5:01 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Details on New Features > > On 04.05.2012 16:39, Richard Hipp wrote: > > > If a single min() or max() aggregate function appears in a query, > then > > any other columns that are not contained within aggregate functions > > and that are not elements of the GROUP BY will take values from one > of > > the same rows that satisfied the one min() or max() aggregate > function. > > Given that more than one row satisfies the one min() or max() aggregate > function (think of multiple, identical smallest or largest values). > Which row will SQLite pick? > > Ralf > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
