3 ms·
> Aggregate functions can now include an ORDER BY clause after their last parameter. Hopefully that means we'll soon get support for `DISTINCT` in `GROUP_CONCA
by stux 3y ago
> Aggregate functions can now include an ORDER BY clause after their last parameter.
Hopefully that means we'll soon get support for `DISTINCT` in `GROUP_CONCAT`.
Atm you can do `group_concat(x, '|')` and `group_concat(distinct x)`, but you can't do `group_concat(distinct x, '|')`.
- jddj 3y agoYeah this would be nice