Picking up a row based on max value

I have a usecase in which I get the files from some software that has record as follows -

Item Account Paid …
1 2.05
1 1.00
1 3.05
2 4.00
3 5.00

Now, I want to select the records having max value from account paid.It is like data base query pick max( account paid) group by item in RDBMS world.

I was able to group records but is there a way where I can select max( account paid ) value using snap ?

Any help much appreciated here…

Thanks…