OK, thanks for confirming that. RBS
On 9/12/12, 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. > > >> >> RBS >> _______________________________________________ >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
