sql server 删除重复数据保留一条!

CREATE VIEW [dbo].[tmp_view] AS
SELECT
  ROW_NUMBER() OVER (PARTITION BY name, addr ORDER BY (SELECT 1) ) AS no,
  name,
  addr
FROM
  Test
GO
创建视图，

delete  from tmp_view  where no!=1