数据重复了，请问如何删除重复的，保留（centerid有数值）的记录，SQL SERVER实现，求教！
------解决思路----------------------
准确来说，它并没有重复，执行前先备份
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