sql server 小技巧(2) 删除sql server中重复的数据

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

with list_numbers as
(
select Name, AuthorOrTime, Url, Price, EstimatePrice, Size, Category,
ROW_NUMBER() over (order by Name, AuthorOrTime, Url, Price, EstimatePrice, Size, Category) as 'rownumber'
from Arts
)
delete list_numbers where rownumber not in
(
select min(rownumber) from list_numbers group by Name, AuthorOrTime, Url, Price, EstimatePrice, Size, Category
)

sql server 小技巧 集锦