>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 (select Code, max(date) as LastDate from Codes group by Code) 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