On 5 January 2016 at 00:14, Yuri <yuri at rawbw.com> wrote: > Please consider this example: . . . > The 'order by' clause doesn't work, because if it did the result would have > been: > 1|x,y > 2|x,y > > sqlite3-3.9.2 > > Yuri
See http://www.sqlite.org/lang_aggfunc.html last sentence " group_concat(X) group_concat(X,Y) The group_concat() function returns a string which is the concatenation of all non-NULL values of X. If parameter Y is present then it is used as the separator between instances of X. A comma (",") is used as the separator if Y is omitted. The order of the concatenated elements is arbitrary. " Regards, Simon
