_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › 覓語伎豢蠍
|
|
[edit]
願屋 #declare @s varchar(200) , @result varchar(200) = '' set @s = 'aaaaaaaaabbbca' ;with dummy as ( select 1 seq union all select seq + 1 from dummy where seq + 1 <= 1000 ) select @result = @result + concat(s, count(*)) from ( select substring(@s, seq, 1) s , seq , seq - row_number() over(partition by substring(@s, seq, 1) order by seq) grp from dummy where seq <= len(@s) ) t group by grp , s order by min(seq) option (maxrecursion 0); select @result 豢覓語, len(@result) 蠍語
鏤
|
語 譯朱覦 碁朱れ 炎概蠍 覦 レ覓殊 覿豎れ 螳 讀覈 譴. 蠏碁れ 蟇磯 ろ 蠍磯ゼ 讌 蠍 覓語 豪Μ螳 . (B.C 觚) |