RE: SQL count?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> client transaction type
> C1		A
> C1		A
> C1		B
> C1		C
> C1		A
>
> how can I display the result :
>
>
> Client	count	count
> C1		3	2

Select sum(case when ttype='A' then 1 else 0 end) as count_a,
       Sum(case when ttype='B' then 1 else 0 end) as count_b,
       Sum(case when ttype='C' then 1 else 0 end) as count_c
> From mytable
Where something = avalue


Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you steal something small you are a petty thief, but if you steal
millions, you are a gentleman of society."
        -- Greek Proverb
"We hang the petty thieves and appoint the great ones to public office."
        -- Aesop