for each different entry in column 1 extract maximum values from column 2 in unix/awk

Shell Programming and Scripting
1

Hello,

I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2

SDF4     -0.211654
        SDF4     0.978068
        SDF4     -0.211654
        SDF4     -0.211654
        FAM132A  -0.210704
        FAM132A  -0.210704
        FAM132A  -0.210704
        UBE2J2   -0.238536
        UBE2J2   1.9916
        UBE2J2   0.190829
        UBE2J2   -0.234892
        UBE2J2   -0.234892
        UBE2J2   0.190829
        UBE2J2   0.190829

o/p

SDF4     0.978068
FAM132A  -0.210704
UBE2J2   1.9916

Thanks,

3

Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum under special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

More-than-likely, posting homework in the main forums has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on.

If you did post homework in the main forums, please review the guidelines for posting homework and repost.

Thank You.

The UNIX and Linux Forums.