Re: Where clause

am Tue, dem 26.06.2007, um 10:24:05 +0200 mailte Michael Landin Hostbaek folgendes:
> 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;
>
> I guess I have to put where (click = true or view = true) - and
> differentiate them in the SELECT target.. ?

*untested*

select cid, sum(case when click = true then 1 else 0 end), sum(case when
view = true then 1 else 0 end) from ...

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net