Re: [sqlite] group_concat() reverses order given where clause?

[Dan Kennedy]

On 08/15/2017 10:12 PM, Bob Friesenhahn wrote:

select group_concat(name, ' ') AS 'names' from moca_config where enable == 1 order by name;

Maybe this:

select group_concat(name, ' ') AS 'names' from (
  SELECT name FROM moca_config where enable == 1 order by name
);


Dan.


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users