sql查询语句

去除重复

delete from [cxp_sx].[dbo].[查询]
 where name  in (select  name  from [cxp_sx].[dbo].[查询]  group  by  name   having  count(name) > 1)
 and no not in (select MAX(no) from  [cxp_sx].[dbo].[查询]  group by name  having count(name )>1)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------