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? Or does that merely order the (one) returned record :-) -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users