Link to home
Start Free TrialLog in
Avatar of maximus1974
maximus1974

asked on

How to keep a record with the highest value

I want to keep only records with the highest value when a duplicate exists. The column containing the highest value is named Revision and the column containing the duplicate is named Manual_ID.

Ex:

     Manual_ID               Revision
  22.11.20_A1234               4
  22.11.20_A1234               5

I want to keep only the record containing Revision 5.
SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial