SELECT name, color, Sum(price) AS price FROM key_table5 WHERE price >
'2' GROUP BY color ASC ORDER BY name ASC LIMIT 50 OFFSET 0
when either ASC or DESC is used with the GROUP BY clause.
Is this a bug or a query statement inaccuracy on my part?
Looks like a documentation bug. Indeed the select-core diagram
incorrectly shows an ordering-term in the GROUP BY clause. It should
probably be named grouping-term instead, with grouping-term being
defined as a comma-separated list of column expressions.
Others have already commented on the semantic of your query.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users