I have found some code to split duplicate records into a seperate query, but I'm looking for a way to count the consecutive duplicate rows in a query without splitting them into seperate datasets. For example, I'm looking for an output like the "Dupicate_Count" column below:
Name Duplicate_Count
Mary 0
Mary 1
Mary 2
Bob 0
Bob 1
Bob 2
Bob 3
Fred 0
Fred 1
Fred 2
... View more