latest price and product name

Question

i have two tables 1. Product and 2.Product_Price

The tables have below columns 1.Product(ID PK,Product) 2.Product_Price(ID FK,Price,date)

the two ID is relationship.

i need the query for latest price and product name.

Answer 1

0

How about

;WITH CTE AS
(
SELECT Product, Price, ROW_NUMBER() OVER (PARTITION BY P.ID ORDER BY PP.Date DESC) Rownum
FROM  Product P INNER JOIN Product_Price PP ON P.ID = PP.ID
)

SELECT * FROM CTE WHERE Rownum = 1

answered Jul 19 '12 at 12:32 PM

Usman Butt
13.8k ● 6 ● 8 ● 14

(comments are locked)

latest price and product name

Follow this question

Related Questions