In a request, we have to count and serialize the duplicated values in such manner (see Col2):
Col1
Col2
a
1
b
1
a
2
a
3
c
1
Here, we have 3 duplicated rows in Col1. User's request is to count gradually as loading script goes. Perhaps it's like comparing value with Previous(Col1), and if so, sum....How could we achieve such count?
*To obtain the total duplicated count, it is rather easy to group by and count Col1. But if we had to count as loading script goes, I wonder what could be the possibility?
