How to know if one field of the database table has many associated records
Posted on 2011-09-21
I have a table T which has rows A,B,C,D
Records shown under A have records associated against it under B
How do I determine if a record under A has more than one unique value associated with it under B..
Remember the Table has got more than 70K+ Records
Would like to see the output some thing like
A B Count
--- ----- ----------
1 12 4
2 0 1
3 23 3
I hope the question is understood and also the expected output
Please help experts need a solution at the earliest.......