| From: | Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Query |
| Date: | 2007-12-10 12:23:49 |
| Message-ID: | 912434.25800.qm@web94312.mail.in2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-12-10 12:44:09 | Re: Query |
| Previous Message | Richard Huxton | 2007-12-10 09:49:55 | Re: Problems with acessing xml functions on other database |