Sqlserver删除重复记录只保留一条

最新推荐文章于 2024-08-12 03:16:23 发布

Nsy_Gamer

最新推荐文章于 2024-08-12 03:16:23 发布

阅读量508

点赞数

本文链接：https://blog.csdn.net/Nsy_Gamer/article/details/50790264

版权

新建测试表

CREATE TABLE tt(

[pid] [nchar](10) NULL,
[Salary] [int] NULL,
[ID] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

插入测试数据

insert into tt(pid,Salary)values(1 ,1000)
insert into tt(pid,Salary)values(2 ,33)
insert into tt(pid,Salary)values(2,3000)
insert into tt(pid,Salary)values(5,44)
insert into tt(pid,Salary)values(3,44)
insert into tt(pid,Salary)values(3,44)
insert into tt(pid,Salary)values(3,555)
insert into tt(pid,Salary)values(5,33)
insert into tt(pid,Salary)values(4,55)

删除语句

delete tt where id not in(

select MIN(ID) from tt group by pid
)