I have one question..I have one table named emp, which contains onw column called emp_name..and that coloumn contais following records
Sam
Tam
Ram
Dam
Zam
Sam
Sam
Tam
As it shows I have some duplicate records in this . Now I just want to delete only the duplicate records i.e. if I have 4 Sam's then only three should get deleted .