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