_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 覓語伎豢蠍

覓語 #

覓語 aaaaaaaaabbbca襯 a9b3c1a1 螳 豢螻 矩.

願屋 #

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) 蠍語
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

螻手碓螳 朱 覩碁螳 .