From: | "news(dot)gmane(dot)org" <nis(at)superlativ(dot)dk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Where clause |
Date: | 2007-06-26 15:22:26 |
Message-ID: | f5ravm$37c$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Michael Landin Hostbaek skrev:
> Hello,
>
> I have a table called tracking, with a contactid varchar, click bool,
> view bool and cid varchar.
>
> I would like to put the following into one single query if possible:
>
> // Number of clicks
> select cid,count(distinct contactid) from tracking where click =
> true group by cid;
>
> // Number of views
> select cid,count(distinct contactid) from tracking where view =
> true group by cid;
Untested, not the cleverest formulation, but something like this should
work:
SELECT * FROM
(
select cid,count(distinct contactid) from tracking where click =
true group by cid
) c1
FULL OUTER JOIN
(
select cid,count(distinct contactid) from tracking where view =
true group by cid
) c2
USING (cid);
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2007-06-26 16:15:16 | Re: NO DATA FOUND Exception |
Previous Message | Bart Degryse | 2007-06-26 14:36:59 | Re: NO DATA FOUND Exception |