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 pai...