>My requirement is not max rate, I want to select Last Purchase Rate of each code > >Rgds: >Ahsan Rana
Do you mean last rate by date? If so, change my query this way:
select T1.* from Codes T1 inner join (selectCode, max(date) as LastDate from Codes groupbyCode) T2
on T1.Code = T2.Code and T1.Date = T2.LastDate && If you have exact same dates for a code all records with last date will be selected