Itemno Position 0110.01 CPO 0543.01 ACPO 0543.02 ACPO 0840.01 AC 0840.02 AC 3125.01 SC 3180.10 WPTI am trying to to count distinct positions as follows:
CPO 1 ACPO 2 AC 2 SC 1 WPT 1when I run this sql statement:
SELECT DISTINCT cursor1.e_class FROM cursor1it 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