SQL SERVERɾ³ýÖظ´Êý¾Ý

--²éѯÖظ´Êý¾Ý

SELECT * from Êý¾Ý±í WHERE (Öظ´Êý¾Ý×Ö¶Î) in (select Öظ´Êý¾Ý×ֶΠfrom Êý¾Ý±í group by Öظ´Êý¾Ý×ֶΠhaving count(*)>1)
ORDER BY Êý¾Ý±í.Öظ´Êý¾Ý×Ö¶Î

--ɾ³ýÖظ´ÁÐ
delete from Êý¾Ý±í where ID not in
(select max(ID) as ID from Êý¾Ý±í group by Öظ´Êý¾Ý×Ö¶Î)