Hello there, I am having data in table something like below: user_id type_id 1 1 1 2 2 1 3 3 4 3 5 1 1 10 7 6
What i want is the count of all user group by type_id who are subscribed to only one type e.g type_id count 1 2 6 1 any suggestions? Thanks in advance With regards Ashish --------------------------------- Unlimited freedom, unlimited storage. Get it now