Remove dublicates

[Anon]

Hi,

I have this table:

AddressID CategoryID

1 2
1 3
2 4
3 5
3 6

I need to remove these
1 3
3 6
Cause there should't be any numbers with
the same AddressID is this database. So there can only be one (doesn't mather wich ine) the rest has to be deleted.
I need to filter an old database so
preventing double entries by Unique ID's etc
is not an issue here.

Tnx!

[[deleted]]

Preventing doubles by unique_id's may not be an issue, but it is a solution.

Create a new table that has exactly the same structure as the old table, except: add a unique constriant on the column that should not contain duplicates.
Then do something like
INSERT INTO table SELECT * FROM othertable;

And your new table will reject all duplicates for that single column.