How can I identify and delete these duplicates?
Posted on 2012-09-07
I've got a table that looks like this
id contestant_id voter_id contest_end_date ballots
In some instances, I'm getting entries like this:
1 12345 0000 2012-09-30 1
2 12345 0000 2012-09-30 1
3 67890 1111 2012-09-30 4
Entry #3 is gold, but the first two represent duplicates that I need to delete. So, in light of the fact that the duplicates are defined in terms of two columns rather than just one, how do I identify them and then how do I delete them in the context of a loop / delete dynamic?