SELECT e_class, count(e_class) FROM cursor1 GROUP BY e_classAlan
>Itemno Position > >0110.01 CPO >0543.01 ACPO >0543.02 ACPO >0840.01 AC >0840.02 AC >3125.01 SC >3180.10 WPT >>
>CPO 1 >ACPO 2 >AC 2 >SC 1 >WPT 1 >>
>SELECT DISTINCT cursor1.e_class FROM cursor1 >>it gives me distinct postions, but don't know how to get the count of the distinct postions. Does any know what I am doing wrong