Cecil Westerhof wrote: > I always use an ORDER BY after a GROUP BY. Without an ORDER BY, there is no guarantee that the result has any specific order (in SQLite and in any other SQL database).
> 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. Are you sure? How does the output of EXPLAIN QUERY PLAN look like? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users