How to get Last Purchase price in SQL

Apr 15 2016 1:32 PM

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

then result should

itemCode	PurchaseDate	Price
A	02-Mar-2011	6

How to do this

Thanks

Basit.

Answers (3)

Full Text Index