Re: Where clause

["A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>]

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