删除重复数据 mssql2008r2

来源:互联网 发布:创建一个数据库sql语句 编辑:程序博客网 时间:2024/05/17 21:50


delete from pagehost where id in

 (
select id from
(
 select ROW_NUMBER()over (partition by webhost order by id )tt,id from pagehost
)ph where tt>1
)

0 0
原创粉丝点击