On 1/19/2011 12:51 PM, Noah Hart wrote: >> select E, replace(group_concat(distinct T), ',', ';'), >> replace(group_concat(distinct P), ',', ';') from MyTable; > >Ahhh > the DISTINCT keyword was what I'm missing. However, this may be a bug, > when I use group_concat(DISTINCT T, ';') I get the error message > DISTINCT aggregates must have exactly one argument
That's why I had to muck around with replace(). The syntax only allows DISTINCT keyword in aggregate functions taking exactly one parameter. group_concat defaults to comma as a separator when called with one parameter. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
