;WITH cte AS
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY ProductCode ORDER BY Id DESC) AS rn
FROM ProductPriceInfo
)
SELECT *
FROM cte
WHERE rn = 1
查询每一组的第一行
有时候不是我们失去了目标,而是失去了方向。
;WITH cte AS
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY ProductCode ORDER BY Id DESC) AS rn
FROM ProductPriceInfo
)
SELECT *
FROM cte
WHERE rn = 1