Hi, There appears to be an error in the description of the SELECT statement on http://www.sqlite.org/lang_select.html .
The GROUP BY clause in the select-core part http://www.sqlite.org/images/syntax/select-core.gif refers to ordering-term. Ordering-term http://www.sqlite.org/images/syntax/ordering-term.gif suggests it is possible to specify ASC or DESC, which of course is true for ORDER BY, but not for GROUP BY. Thanks to 'iSteve' on Internet Relay Chat (network freenode.net, channel #sqlite) for bringing this to our attention. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list email@example.com http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users