if (select count(*) from HY where
CardCode in( select CardCode from HY
group by CardCode
HAVING count( CardCode) >1))>0
print '会员卡号有重复'
CardCode in( select CardCode from HY
group by CardCode
HAVING count( CardCode) >1))>0
print '会员卡号有重复'