How to remove duplicate Records from a Table?

i wants query of about that

Naveen
Views: 634 | 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 )






What do you think? Add your opinion/answer
*Name
*your opinion/answer:

Home | Popular Topics | Ask a New Question | Contact us © TechBaba.com 2011

Content is created by Community. TechBaba.com does not guarantee the accuracy!