Originally posted by marist89
Oh, so you do have a PK.

Using the exact query you specified, I would create a temporary table of all my unique combinations. Then, I would figure out which row I want to drop with a min/max function and put that in the temporary table too. Once I knew the rows I wanted to delete, I would delete them from my base table.
Jeff,
i dont have a PK on the table at all. It can have multiple records with the same account Id .

Can it be done using one query/delete statement

Thanks