create table #TempTable
(
mobile varchar(20),
memo varchar(30)
)
insert into #TempTable
select '18966668888','春哥1'
insert into #TempTable
select '18966668888','春哥2'
insert into #TempTable
select '15855558888','曾哥1'
insert into #TempTable
select '15855558888','曾哥2'
;with temp
as
(
select *,row_number() over(PARTITION BY mobile ORDER BY NEWID()) row
from #TempTable
)
select * from temp where row=1
drop table #TempTable