On 11 Nov 2011, at 1:15pm, Igor Tandetnik wrote: > ASC is not valid with GROUP BY, only with ORDER BY. What is it supposed to > achieve, anyway? Your query makes no sense to me.
Igor, I started out to write exactly the same thing, but then I saw the diagram on <http://www.sqlite.org/lang_select.html> which suggests that ASC is legal, even if it doesn't make sense. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users