I have a teable like
ID Name
1 A
2 A
3 A
4 B
5 B
6 C
7 C
8 B
9 A
10 C
I want like this frequency count in increment
ID Name Frequency
1 A 1
2 A 2
3 A 3
4 B 1
5 B 2
6 C 1
7 C 2
8 B 3
9 A 4
10 C 3
I need ms sql query to calculate frequency column
