SQLite Forum

Feature request: ORDER BY in aggregate functions
Login

Feature request: ORDER BY in aggregate functions

(1) By anonymous on 2021-02-26 21:02:13 [link] [source]

My feature request is ORDER BY in aggregate functions. For example:

SELECT GROUP_CONCAT(T, '' ORDER BY V) FROM X;
This is like PostgreSQL.

(2) By anonymous on 2021-02-28 01:46:38 in reply to 1 [source]

I've done what is mentioned previously in the list. It works well though perhaps your suggestion would be simpler.

http://sqlite.1065341.n5.nabble.com/Ordering-a-GROUP-BY-or-other-concatenating-tricks-tp97937p97952.html