I have a table that has following itemno and positions.

Itemno    Position

0110.01   CPO
0543.01   ACPO
0543.02   ACPO
0840.01   AC
0840.02   AC
3125.01   SC
3180.10   WPT

I am trying to to count distinct positions as follows:

CPO  1
ACPO 2
AC   2
SC   1
WPT  1

when I run this sql statement:

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

Thanks
Nick Patel