Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Where clause
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: Michael Landin Hostbaek <mich(at)the-lab(dot)org>, "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Where clause
- Date: Tue, 26 Jun 2007 11:45:21 +0100
Michael Landin Hostbaek wrote:
A. Kretschmer (andreas.kretschmer) writes:*untested* select cid, sum(case when click = true then 1 else 0 end), sum(case when view = true then 1 else 0 end) from ...Thanks, but I need the DISTINCT contactid - I don't want the same contactid counted twice.
... GROUP BY cid -- Richard Huxton Archonet Ltd
- References:
- Where clause
- From: Michael Landin Hostbaek
- Re: Where clause
- From: A. Kretschmer
- Re: Where clause
- From: Michael Landin Hostbaek
- Where clause
- Prev by Date: Re: Where clause
- Next by Date: Re: yet another simple SQL question
- Previous by thread: Re: Where clause
- Next by thread: Re: Where clause
- Indexes: