这个经常用免得下次再去找。
select * FROM PatientBaseInfo where id<>(select max(id)
from PatientBaseInfo d where PatientBaseInfo.CardNumber =d.CardNumber )AND CardNumber in (select CardNumber from PatientBaseInfo b
GROUP BY CardNumber HAVING COUNT(CardNumber)>1)
delete FROM PatientBaseInfo where id<>(select max(id)
from PatientBaseInfo d where PatientBaseInfo.CardNumber =d.CardNumber )AND CardNumber in (select CardNumber from PatientBaseInfo b
GROUP BY CardNumber HAVING COUNT(CardNumber)>1)