重复数据
select * from dai_credit_apply ca where (ca.cid,ca.companyid) in (select cid,companyid from dai_credit_apply WHERE status=2 GROUP BY cid,companyid HAVING count(*)>1)
重复数据
select * from dai_credit_apply ca where (ca.cid,ca.companyid) in (select cid,companyid from dai_credit_apply WHERE status=2 GROUP BY cid,companyid HAVING count(*)>1)
评论 0
还没有评论，来说两句吧～