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

Question

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

Answer 1

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