Hmm, maybe I'm wrong there, it would remove duplicates of the entire collection combined, wouldn't it? Yes, it might work.
Staffan On Sun, Jan 11, 2015 at 12:56 AM, Staffan Tylen <staffan.ty...@gmail.com> wrote: > Thanks Richard but unfortunately I cannot use DISTINCT in that way, since > it affects all the selected columns and they are MANY. > > Staffan > > > On Sun, Jan 11, 2015 at 12:43 AM, Richard Hipp <d...@sqlite.org> wrote: > >> On 1/10/15, Staffan Tylen <staffan.ty...@gmail.com> wrote: >> > I'm in the situation where I need to use GROUP_CONCAT and filter out >> > duplicates at the same time. And the default comma separator in >> > GROUP_CONCAT needs to be replaced by a space. I've tried to use function >> > REPLACE to get rid of the comma but only to realise that the data being >> > concatenated also might contain one or more commas. >> > >> >> SELECT group_concat(x,'+') FROM (SELECT DISTINCT a+b AS x FROM tab ORDER >> BY 1); >> >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
