如何消除以下SQL数据值的重复？ [关闭]

I need to eliminate NIC Number duplicate situation.please provide me SQL Query for that.

enter image description here

DELETE FROM Table_Name A
INNER JOIN (SELECT NIC, COUNT(*) AS RecCount, MIN(RESULT) AS OlderValue 
            FROM Table_Name 
            GROUP BY NIC) b
ON A.NIC = b.NIC 
AND a.RESULT != b.OlderValue

WHILE EXISTS (SELECT NIC FROM TABLE_NAME
              HAVING COUNT(NIC) > 1)
DELETE TOP 1 FROM TABLE_NAME WHERE NIC IN (SELECT NIC FROM TABLE_NAME HAVING COUNT(NIC) > 1) ORDER BY SubjectID DESC