Tags

,


Delete Dublicate Records

To remove Dublicate Records from table, a very simple query

Delete T1
From EOI T1, EOI T2
Where T1.EoiNo = T2.EoiNo
And T1.ID > T2.ID

enjoy!!!!

Advertisements