Max value Record from a File

Shell Programming and Scripting
1

I have a file with 3 columns

I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them.

empid,ename,Sal
1,abc,100
2,def,200
3,xyz,300
4,pqr,100
5,mnq,300

Output
Any record with 300 as salary

---------- Post updated 03-21-12 at 10:08 AM ---------- Previous update was 03-20-12 at 03:14 PM ----------

I was sorting based on the amount column and then doing a head -1 for the data.Is this the correct approach?

2

See if this works for you:

#!/bin/ksh
mMax=$(sort -t, -n -k3 b | tail -1 | sed 's/.*,//')
egrep ",${mMax}$" b