sqlserver查询重复数据，删除并保留一条。

或与且与或非

2022-09-22 96 阅读1分钟

sqlserver去除重复数据

查询重复数据
- 删除重复数据只保留一条

查询重复数据

	  select *  from SHSJ0101 where  XSDM in (select XSDM from SHSJ0101 where SHSJPCDM = 'b1f492d67da743dc838e214195a2a524'  group by XSDM having count(XSDM) > 1) and SQSJ not in(select  max(SQSJ) from SHSJ0101 where SHSJPCDM = 'b1f492d67da743dc838e214195a2a524' group by  XSDM having count(XSDM) > 1 )and SHSJPCDM = 'b1f492d67da743dc838e214195a2a524'

删除重复数据只保留一条

delete from SHSJ0101 where  XSDM in (select XSDM from SHSJ0101 where SHSJPCDM = 'b1f492d67da743dc838e214195a2a524'  group by XSDM having count(XSDM) > 1) and SHSJPCDM = 'b1f492d67da743dc838e214195a2a524'  and SQSJ not in(select  max(SQSJ) from SHSJ0101 where SHSJPCDM = 'b1f492d67da743dc838e214195a2a524' group by  XSDM having count(XSDM) > 1 )