问题:
给定字符串‘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