I am trying to clean up a table that was bulk loaded with a bunch of duplicate records and I wanted to only keep the MAX(DATEOFFERRED) of the grouped records in the query below. The problem is the MAX(DATE_OFFERRED) has multiple of the same DATEOFFERRED date. So what I want to do is only keep the first of the max date offerred grouped records. Can anyone assist with this?
SELET count(*) FROM Availables t
,MAX(DateOfferred) [Latest Date Offerred]
t.Part_No = Latest.Part_No
AND t.Qty = Latest.Qty
AND t.Price = Latest.Price
AND t.DateOfferred <> Latest.[Latest Date Offerred]