Duplicates query with a twist

[coach.32]

I have a table that I need to eliminate certain duplicates from. An example of the data is:
Account - Team
14983 - 1743
14983 - 38466
15621 - 38466
15000 - 38466
19816 - 1743
15621 - 38466
My problem is that I need to remove duplicates but in the same instance I need to keep a certain Team number. In the above sample data I have the account number 14983 that has 2 different team numbers. I want to keep the 1743 and also with the account number 15621 I just need to keep one of the 38466 records. Is there anyway I can achieve this? Any assistance would be greatly appreciated. Thank you in advance.

 

[plog]

Possibly. For Account=14983, how would the system know to keep 1743 and not 38466? With the data you have provided it doesn't seem possible to know that. Is there another field used to determine this--possible a Date field?