?

主鍵為ID

select * from [infotops] where Id in (select max(id) from [infotops] group by InfoId)?

?

?

----------------------------------------------------- 鞏固----------------------------------------------

group by?

?

PARTITION BY ?看圖比較區(qū)別

SELECT ROW_NUMBER() OVER ( PARTITION BY Infoid order by id desc) rowNum ,
*
FROM [InfoTops] t1 with(nolock) ?---》

?

with infos as
(
SELECT ROW_NUMBER() OVER ( PARTITION BY Infoid order by id desc) rowNum ,
*
FROM [InfoTops] t1 with(nolock)
)
select * from infos where rowNum=1 ? ---------------》

?

?

轉(zhuǎn)載于:https://www.cnblogs.com/kunlunmountain/p/4502342.html

總結(jié)

以上是生活随笔為你收集整理的SQl 根据某列去重 partition by的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。