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 )