SQLite version 3.7.9 2011-11-01 00:52:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a); sqlite> select avg(a) from t order by avg(a); -- order by aggregate possible
sqlite> select 1 from t order by a; -- order by column not in result possible sqlite> select 1 from t group by 1 order by avg(a); -- order by aggregate not in result possible sqlite> select 1 from t order by avg(a); -- should be possible Error: misuse of aggregate: avg() sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users