34,576
社区成员
发帖
与我相关
我的任务
分享
--兼容SQL2000的方式
SELECT * FROM TB T1
WHERE NOT EXISTS(
SELECT * FROM TB T2
WHERE T1.goodsid=T2.goodsid
AND T1.id<T2.id)
--SQL2005+
;WITH CTE AS(
SELECT id,goodsid,goods_price
,ROW_NUMBER()OVER(PARTITION BY goodsid ORDER BY id DESC)RN
FROM TB
)
SELECT id,goodsid,goods_price FROM CTE WHERE RN=1