On 23 Nov 2011, at 4:17pm, Wiktor Adamski wrote: > sqlite> select 1 from t order by avg(a); -- should be possible
Why should this be possible ? For an 'ORDER BY' you need a value for each row. But aggregate functions produce only one value for the whole SELECT command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
