原文:

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

)