Sql删除重复操作

原创于 2015-11-12 18:17:48 发布 · 738 阅读

·

0

·

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;