Situation : I have fields sessionId and personName. This session ID has many-to-may mapping with personName.
Need is : I want the count of personName associated with sessionId.
Query I am using : | table sessionId, personName, it gives following
sessionId personName
1. 1234 Name1
2. 1234 Name 2
3. 1234 Name1
4. 1234 Name3
5. 4321 Name1
6. 4321 Name3
7. 4321 Name3
What I want :
sessionId personName count
1. 1234 Name1 2
2. 1234 Name2 1
3. 1234 Name3 1
4. 4321 Name1 1
5. 4321 Name3 2