On Fri, May 4, 2012 at 5:02 PM, Richard Hipp <d...@sqlite.org> wrote:
> > > 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. > Correction: The one that it encounters first, since subsequent rows of the same value will not trigger a new copy of values into the output registers, since only a new min/max does that. > > >> >> 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
