Query - Mailing list pgsql-general

From Ashish Karalkar
Subject Query
Date
Msg-id 912434.25800.qm@web94312.mail.in2.yahoo.com
Whole thread Raw
Responses Re: Query
Re: Query
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problems with acessing xml functions on other database
Next
From: Richard Huxton
Date:
Subject: Re: Query