Answer: Declare @String Varchar(100)
Select @String = 'Pandian'
;With CTEs
As
(
Select LEFT(@String,0) Chars,0 [String]
Union All
Select Substring(@String,[String]+1,1) Chars,[String]+1 From CTEs Where [String] <=LEN(@String)
)
Select Chars [Letter], COUNT(1) [Repeats] from CTEs Where Chars <>'' Group by Chars
Go
Result:
Letter Repeats
------ ------
a 2
d 1
i 1
n 2
P 1
Asked In: Many Interviews |
Alert Moderator