BrenoAguiar
IS-IT--Management
I have a table like this:
ID Name Bcode Ccode
1 John 211 212
1 John 211 301
2 mary 020 025
2 mary 020 056
2 mary 020 059
3 cathy 112 115
And I need to count the records to show how many times "John" (or ID=1) shows and the same for "mary" and "cathy". I'm not that familiar with the DistinctCount Function, if that is the solution.
Any Help?
ID Name Bcode Ccode
1 John 211 212
1 John 211 301
2 mary 020 025
2 mary 020 056
2 mary 020 059
3 cathy 112 115
And I need to count the records to show how many times "John" (or ID=1) shows and the same for "mary" and "cathy". I'm not that familiar with the DistinctCount Function, if that is the solution.
Any Help?