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