On Wed, Sep 12, 2012 at 7:51 AM, Tim Streater <[email protected]> wrote:
> On 12 Sep 2012 at 11:37, Richard Hipp <[email protected]> wrote: > > > On Wed, Sep 12, 2012 at 6:15 AM, Bart Smissaert > > <[email protected]>wrote: > > > >> Had a look at the new option as in the SQL above. > >> Noticed it will only return one record, even if there are more records > >> where > >> field1 equals max(field1). > >> I suppose it returns the first record it finds where field1 = > max(field1). > >> Is this indeed how it works? > > > Yes. > > Is there any means of influencing which record would be returned in this > circumstance, such as by an ORDER BY? > No. If you have multiple rows with the same maximum value, then the one that ends up being returned is arbitrary. > > -- > Cheers -- Tim > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
