sql - Count Of Distinct Characters In Column -

sql - Count Of Distinct Characters In Column -

say have next info set

column1 (varchar(50 or something)) elias sails pails plane games

what i'd produce column next set:

letter count e 3 l 4 3 5 s 5 , on...

one solution thought of combining strings single string, , count each instance of letter in string, feels sloppy.

this more exercise of curiosity else, but, there way count of distinct letters in dataset sql?

i creating table of letters similar to:

create table tblletter ( letter varchar(1) ); insert tblletter ([letter]) values ('a'), ('b'), ('c'), ('d'); -- etc

then bring together letters table info letter:

select l.letter, count(n.col) total tblletter l inner bring together names n on n.col '%'+l.letter+'%' grouping l.letter;

see sql fiddle demo. give result:

| letter | total | |--------|-------| | | 5 | | e | 3 | | g | 1 | | | 3 | | l | 4 | | m | 1 | | p | 2 | | s | 4 |

sql sql-server count distinct-values