Distinct Count problem 1

[pacificpear]

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

 

[amrita418]

Try this:

select      a,  
            b, 
            count(distinct c)
from        TableA
group by    a, b

Regards,
AA