Given the following table:
DROP TABLE IF EXISTS key_table5;
CREATE TABLE key_table5 (
name TEXT NOT NULL default '',
color TEXT default NULL,
price REAL default NULL,
UNIQUE (name),
PRIMARY KEY (color)
);
I'm getting the following exception:
SQLException: [SQLITE_ERROR] SQL error or missing database (near "ASC": syntax
error)
with:
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?
SQLite version 3.7.2 & 3.7.9.
danap.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users