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?
RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
