Out of curiosity, why is the "a < INF" clause (or something like "a < 99999999" in the original question) there? It doesn't seem to limit the results, and even if the overhead of having it there is minimal, does the fact that no one's suggested removing it mean it's needed/useful?
SELECT max(a) from table where a<INF AND b=8 and c=1; Thanks, Graham. Sent from Samsung Galaxy Note _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users