今年写的最牛的sql:
select count(*),bb.item from (
select aa.aac002
,array_to_string(ARRAY(
SELECT
unnest(array_agg(aa.aae140))),',') item from (
select
aac002,aae140
from xxxxxx where aae003 = '202012' group by aac002,aae140 order by aac002,aae140) aa group by aa.aac002)bb
group by bb.item