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.

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

Select top 1 * From table_name order by PurchaseDate Desc

Select top 1 Itemcode From table_name order by PurchaseDate Desc

Answers

How to get Last Purchase price in SQL

Basit Khan

2.3k

1 SQL Server

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.

How to get Last Purchase price in SQL

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)