海量數(shù)據(jù)（百萬(wàn)以上），其中有些全部字段都相同，有些部分字段相同，怎樣高效去除重復(fù)？

如果要?jiǎng)h除手機(jī)(mobilePhone)，電話(officePhone)，郵件(email)同時(shí)都相同的數(shù)據(jù)，以前一直使用這條語(yǔ)句進(jìn)行去重：

delete from 表 where id not in
(select max(id) from 表 group by mobilePhone,officePhone,email )
or
delete from 表 where id not in
(select min(id) from 表 group by mobilePhone,officePhone,email )

delete from 表 where id not in
(select max(id) from 表 group by mobilePhone,officePhone,email )
or
delete from 表 where id not in
(select min(id) from 表 group by mobilePhone,officePhone,email )