Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amitesh Kumar Deleting Duplicate Records RE: Deleting Duplicate Records
rotto
SSC Veteran
Points: 267
More actions
December 24, 2008 at 7:20 am
#917375
delete * from employee where id NOT IN (select min(id) from employee group by employeeno,employeeid)
This will delete all duplicated records and leave one unduplicated record
RickO