Re: [sqlite] Can you use ORDER BY clause in aggregate functions?

2018-09-07 Thread Keith Medcalf
>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

[sqlite] Can you use ORDER BY clause in aggregate functions?

2018-09-07 Thread sqlite
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