Loading

How to get Last Purchase price in SQL

Basit Khan

10y2.4k

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Basit Khan10y ago
Thanks,

but i want for this for each item code

e.g

ItemCode PurchaseDate Price
A 01-Mar-2010 4
A 02-Mar-2011 6
B 6-Apr-2015 8
B 8-Apr-2015 7

then what will be the query
0
Rahul Chavan10y ago
Select top 1 * From table_name order by PurchaseDate Desc
0
Vignesh Mani10y ago
Select top 1 Itemcode From table_name order by PurchaseDate Desc
0