How to Remove Actual Duplicate Values

Problems!!! I have a database. Where there is a column called NID. NID numbers are usually 10, 13 and 17 digits. After applying the duplicate value in the NID column, I see that if the 10 and 13 di...