Sql删除重复操作

DELETE AAA FROM(select * ,row_number() over (partition by  [uID],type,CONVERT(varchar(100), [CreateTime], 102) order by  [CreateTime]) as numrowfrom [test].[dbo].[Tests])  AAA where numrow>1 and AAA.Type=1;goDELETE AAA FROM(select * ,row_number() over (partition by  [uID],type,CONVERT(varchar(100), [CreateTime], 102) order by  [CreateTime] desc) as numrowfrom [test].[dbo].[Tests])  AAA where numrow>1 and AAA.Type=2;