2018-05-21

2018 年 5 月 21 日2018 年 5 月 21 日 by 沧海之树 In 工作

select PhoneNumber from CustomerPhoneNumber group by PhoneNumber having count(PhoneNumber)>1

 

delete CustomerPhoneNumber where ID in (
select ID from(
select ROW_NUMBER() over (partition by PhoneNumber order by PhoneNumber) rn,ID from CustomerPhoneNumber
) as t
where rn>1 )