sqlserver删除重复数据的方法

方法一：

delete T from (
select  ROW_NUMBER() over (Partition By FUN_CODE order by [FUN_ID]) as rown ,* from AU_FUN_AUTH t where  FUN_NAME ='XXXX') T   where T.rown >1

方法二：

查看：

select resource_id,count(1) from t_resource_apptype_releation  GROUP BY resource_id having count(1)>1 order by count(1) desc 

删除：

delete aa from t_resource_apptype_releation aa where  exists(select * from t_resource_apptype_releation where aa.id>id and  resource_id=aa.resource_id)