[Solved] How To Eliminate Duplicates of Following SQL Data Values? [closed]

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