工作中遇到一个需求,系统中针对一辆车会填报多个问题,在统计时希望展示一辆车一行记录,所有问题描述汇总在一个字段展示。
分组不去重拼接
select
group_field,
,concat_ws(',',collect_list(cal_field)) as result_field
from tableName
group by group_field;
分组去重拼接
select
group_field,
,concat_ws(',',collect_set(cal_field)) as result_field
from tableName
group by group_field;