- Joined
- Dec 9, 2008
- Messages
- 1
- Reaction score
- 0
Please can you help me, I have the following data:
AccountID URN
123456 1111
123456 2222
123456 1111
123456 1111
654321 3333
654321 3333
654321 4444
654321 3333
What I want to do is update all the account id's with the same URN. As you can see the same account id can have different URN's so I want to take the most populated URN. i.e. AccountID 123456 I would take URN 1111
AccountID URN
123456 1111
123456 2222
123456 1111
123456 1111
654321 3333
654321 3333
654321 4444
654321 3333
What I want to do is update all the account id's with the same URN. As you can see the same account id can have different URN's so I want to take the most populated URN. i.e. AccountID 123456 I would take URN 1111