On Fri, May 4, 2012 at 5:01 PM, Ralf Junker <ralfjun...@gmx.de> wrote:
> 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? > The row that it encounters last. > > Ralf > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
