On Wed, Sep 12, 2012 at 7:51 AM, Tim Streater <t...@clothears.org.uk> wrote:
> On 12 Sep 2012 at 11:37, Richard Hipp <d...@sqlite.org> wrote: > > > On Wed, Sep 12, 2012 at 6:15 AM, Bart Smissaert > > <bart.smissa...@gmail.com>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 > 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