查询是否存在重复数据
select * from t_crm_variety_approval
where approval_no in (select approval_no from t_crm_variety_approval group by approval_no having count(approval_no) > 1);
查询是否存在重复数据
select * from t_crm_variety_approval
where approval_no in (select approval_no from t_crm_variety_approval group by approval_no having count(approval_no) > 1);