Sql删除重复操作

最新推荐文章于 2024-06-06 10:54:05 发布

原创最新推荐文章于 2024-06-06 10:54:05 发布 · 741 阅读

0 ·

CC 4.0 BY-SA版权

sql 专栏收录该内容

23 篇文章

订阅专栏

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