删除sql server中重复的数据

原文:删除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 )
上一篇:[转]Caffe 深度学习框架上手教程


下一篇:js和jQuery写简单下拉菜单