Oracle 关联查询

select count(1),a.policy_id from gp_pol_prod a where a.product_id=8401 group by a.policy_id having count(1)=1 ;