高效使用脚本从 SQL Server 表中删除重复行

 DELETE T

FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
PARTITION BY bm, ic_lb, ic_zc, ic_cjsj, bdi_sj, bdi_jd, bdi_wd, bdi_wz, bdi_sheng, bdi_shi, bdi_xian, bdi_xiang, bdi_cun, bdi_pm, bdi_p,
bdi_m
ORDER BY (SELECT NULL)
)
FROM IC_BaiduIndex
where bm like '03%'
) AS T
WHERE DupRank > 1