Query

[Ashish Karalkar <ashish_postgre@xxxxxxxxxxx>]

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