Current Data:

RecordIDItemIDMaxOfCost

433923880 $50.00

390563881 $93.75

339413881 $97.50

339703881 $97.50

389503881 $98.75

404173881 $96.56

364913882 $30.00

372653883 $6.50

350543883 $4.50

336583884 $14.94

365853884 $18.77

331343884 $14.75

Results should be:

RecordIDItemIDMaxOfCost

433923880 $50.00

389503881 $98.75

364913882 $30.00

372653883 $6.50

365853884 $18.77

I require the RecordID to use in another query.