Tsql语法
with ops as (
select ROW_NUMBER() over(PARTITION BY 列名1,列名2...,列名N order by(select 0))as rn
from 表名
)
delete from ops where rn > 1
单个字段
with ops as (
select ROW_NUMBER() over(PARTITION BY CustomerID order by(select 0))as rn
from JOIN_CustomerSetting
)
delete from ops where rn >1
多个字段
with ops as (
select ROW_NUMBER() over(PARTITION BY CustomerID,CKey order by(select 0))as rn
from JOIN_CustomerSetting
)
delete from ops where rn >1