Can you use ORDER BY clause in aggregate functions? It seems that you cannot; it is only available for window functions. However, sometimes is useful using ORDER BY with aggregate functions that aren't window functions, such as GROUP_CONCAT function. Therefore is the suggestion to add it if it doesn't already. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] Can you use ORDER BY clause in aggregate functions? sqlite