I've seen a number of variations on this but nothing quite matches what I'm trying to accomplish.
I have a table,
TableA, which contain the answers given by users to configurable questionnaires. The columns are
member_id, quiz_num, question_num, answer_num.
Somehow a few members got their answers submitted twice. So I need to remove the duplicated records, but make sure that one row is left behind.
There is no primary column so there could be two or three rows all with the exact same data.
Is there a query to remove all the duplicates?