准确来说,它并没有重复,执行前先备份SELECT cf_id,sp_no,sp_name,ps_sn,ps_name,[count],MAX(centerid)centerid INTO #t
FROM TB
GROUP BY cf_id,sp_no,sp_name,ps_sn,ps_name,[count]
go
TRUNCATE TABLE TB
go
INSERT INTO tb
SELECT *
FROM #t
FROM TB
GROUP BY cf_id,sp_no,sp_name,ps_sn,ps_name,[count]
go
TRUNCATE TABLE TB
go
INSERT INTO tb
SELECT *
FROM #t
SELECT *
FROM psbasetime where Sp_No = '1-FC-27-27548L-BL-01'
SELECT cf_id,sp_no,sp_name,ps_sn,ps_name,[count],MAX(centerid)centerid
FROM TB
GROUP BY cf_id,sp_no,sp_name,ps_sn,ps_name,[count]
FROM psbasetime
where Sp_No = '1-FC-27-27548L-BL-01'
GROUP BY cf_id,sp_no,sp_name,ps_sn,ps_name
FROM psbasetime
where Sp_No = '1-FC-27-27548L-BL-01'
GROUP BY cf_id,sp_no,sp_name,ps_sn,ps_name黄桑的意思是你的PS_SN这列是否有实际意义,如果只是删除用的话,那select 和group by里不要包含这里就可以了
是我自己弄错了,大神~ 你的方法是正确的,非常+十分感谢very much~~~