Is there a way I could count and index number of time item appear in a list?
something like if first.item then count := 1; else count := count + 1; end if;
item | count |
a | 1 |
a | 2 |
a | 3 |
b | 1 |
b | 2 |
c | 1 |
c | 2 |
c | 3 |
Is there a way I could count and index number of time item appear in a list?
something like if first.item then count := 1; else count := count + 1; end if;
item | count |
a | 1 |
a | 2 |
a | 3 |
b | 1 |
b | 2 |
c | 1 |
c | 2 |
c | 3 |