How can I remove duplicates from a table.
Say I have a table of phonenumbers and status as columns and the key is on both.
I have entries in the table that have the same phonenumber but different status values for a certain reason.
Now I want to get rid of the duplicate phonenumbers.
What sql statement will help me achive that?
Thanks.