SQL中遇到多条相同内容只取一条的实现

(select no=row_number() over(partition by Bid order by getdate()),* from BidWinningNotice) t
where no=1 AND SID=238 AND BWMType=1

技术分享

SQL中遇到多条相同内容只取一条的实现

标签：