Skip to Content
0
Former Member
Oct 18, 2006 at 10:11 AM

LOOP situation

21 Views

Hello experts,

Could you help me with this.

Here's the scenario:

col1 col2

AA 01

AA 00

AA 01

BB 00

BB 01

BB 00

I wanted to know how many 01s and 00s per column 1. so in that scenario.. the result should be:

AA 2 1

BB 1 2

Column2: for all 01

Column3: for all 00

Thanks in advance..