Help with keep the smallest record in file

Shell Programming and Scripting
1

Input file

US	Score	10
UK	Ball	20
AS	Score	50
AK	Ball	10
PZ	Ballon	50
PA	Score	70
WT	Data	10
.
.

Desired output file

US	Score	10
AK	Ball	10
WT	Data	10
.
.

Condition:

  1. If the column 2 is same, keep the record that have smallest number in column 3.
    Thanks for advice.
2

What operating system are you using?

What shell are you using?

What have you tried to solve this problem on your own? Where did what you tried fall short of meeting your goal?

1 Like
3

On top of what Don Cragun already asked, where has the PZ Ballon 50 record gone?