I always use an ORDER BY after a GROUP BY. For example: SELECT used , COUNT(used) FROM usedProverbs GROUP BY used ORDER BY used
But when I leave the ORDER BY out in this case, the result is the same, but it looks like it is a bit faster. I probably keep using it, because in my case the performance is not important and if this works for SQLite3, but not for other databases, it is better to keep using it. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users