>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.
group_concat is already a window function ... _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
