How to get Last Purchase price in SQL

Question

Dear,

 

I have table called Trn_Purchase

fields are

ItemCode

ItemDesc

PurchaseDates

Price

 

I want to get the last purchase price depend on date

 

table have e.g below data

 

ItemCode	PurchaseDate	Price
A	01-Mar-2010	4
A	02-Mar-2011	6

then result should

 

 

itemCode	PurchaseDate	Price
A	02-Mar-2011	6

 

How to do this

 

Thanks

Basit.