how to delete duplicate records from table.
ssprastogi
0
Newbie Poster
Recommended Answers
Jump to PostDELETE FROM table1 USING table1, table1 AS vtable WHERE (table1.ID > vtable.ID) AND (table1.field_name=vtable.field_name)
You may need to have lots of ANDs at the end, if you want lots of fields to be the same. If you just want to delete records that have ONE field the …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.