Hi All,

Could you help me how to get column with contain like an example below using sql
command;

A.data :
type name
A Atype
B Btype
C Ctype
A Atype
D Dtype
B BType
E Etype

B.Result :
type count
A 2
B 2
C 1
D 1
E 1

C.Result :
count Total
2 2
1 3

I know how get result B, but I don't know how to get result C direclty
using data from A. Can someone help me?

Thanks before,

Regards,
-Iip-