Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Where clause
- From: Michael Landin Hostbaek <mich(at)the-lab(dot)org>
- To: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Where clause
- Date: Tue, 26 Jun 2007 11:44:53 +0200
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. Mike
- Follow-Ups:
- Re: Where clause
- From: Richard Huxton
- Re: Where clause
- From: Achilleas Mantzios
- Re: Where clause
- References:
- Where clause
- From: Michael Landin Hostbaek
- Re: Where clause
- From: A. Kretschmer
- Where clause
- Prev by Date: Re: Where clause
- Next by Date: Re: Where clause
- Previous by thread: Re: Where clause
- Next by thread: Re: Where clause
- Indexes: