查找字符串中重复出现的数据

问题：

 

给定字符串‘7003442784,7003333444,8003014272,7003059011,7003305105,7003059206,7003305105,8003014272,7003442784,7003305105’，查找里面重复出现过的字符串

 

 

预期结果：

 

7003442784,8003014272,7003305105

 

 

经过努力，在SQL中实现了该效果。

 

 

将SQL语句贴到这里，

declare @string nvarchar(max)
declare @newstring nvarchar(max)
declare @Spacemark nvarchar(1)
declare @Sreachstring nvarchar(max)

declare @ID bigint
set @ID=0
set @Spacemark=','
set @Sreachstring=''
set @string='7003442784,7003333444,8003014272,7003059011,7003305105,7003059206,7003305105,8003014272,7003442784,7003305105'
while(len(@string)>0)
begin
 if CharIndex(@Spacemark,@string)>1
 begin
  set @newstring=substring(@string,1,CharIndex(@Spacemark,@string)-1)
  set @string=substring(@string,CharIndex(@Spacemark,@string)+1,LEN(@string)-CharIndex(@Spacemark,@string))
   
  if CharIndex(@newstring,@string)>0
   begin
    set @Sreachstring +=@newstring+','
    set @string=replace(@string,@newstring,'')
    set @string=replace(@string,',,',',')
   end
 end
 else
 if CharIndex(@Spacemark,@string)=1
 begin
  if LEN(@string)>1
  begin
   set @string=SUBSTRING(@string,2,LEN(@string)-1)
  end
  else
  begin
   set @string=''
  end
 end
end

if LEN(@Sreachstring)>0
begin
 set @Sreachstring=SUBSTRING(@Sreachstring,1,len(@Sreachstring)-1)
end

select @Sreachstring

运行后得到预期结果：

7003442784,8003014272,7003305105