搜索包含三个名称的标识符


id name
10 统计
10 FCSM
10 EGRUL
9 FCSM
9 EGRUL
8 FCSM
select id from table 
group by id
having string_agg(name, ',' order by name) = 'EGRUL,FCSM,Stat'
order by id

最新更新