How to get counter on basis on how many times records getting repeated.

[vaibhav3339]

Emp    Counter
100        1
110        2
110        2
120        4
120        4
120        4
120        4

I want to achieve the counter column output from Emp column.

[alexnajm · Accepted solution]

Summarize the data, with Group By Emp and Count, then Join that branch back to the original on Emp!