pacificpear
Programmer
Hi
I have to calulate the distinct count. I have the following table.
A B C
0801234 010 A343
0801234 010 A344
0801234 010 A344
0801234 011 A345
0801234 011 A346
0801234 011 A347
0801235 012 A348
0801235 013 A349
* Calucate the dictint count of C
Expected Result
A B Count
0801234 010 2
0801234 011 3
0801235 012 1
0801235 013 1
Can any one help
PP
I have to calulate the distinct count. I have the following table.
A B C
0801234 010 A343
0801234 010 A344
0801234 010 A344
0801234 011 A345
0801234 011 A346
0801234 011 A347
0801235 012 A348
0801235 013 A349
* Calucate the dictint count of C
Expected Result
A B Count
0801234 010 2
0801234 011 3
0801235 012 1
0801235 013 1
Can any one help
PP