How to remove duplicate Records from a Table?

i wants query of about that

Naveen
Views: 275 | Community Opinion: 2

Tags.. SQL Question

Bookmark this page..

Ask a New Question Go to Home

Community Opinion/Answers

Liocus Said..

delete from where rowid < (select max(rowid) from where .=.)

Ketha Said..

DELETE FROM where not in (SELECT min(Id) FROM group by )