From: Wolfgang.Fuertbauer@ebewe.com
To: jdiehl@sandia.gov
Cc: pgsql-sql@postgresql.org
Cc: pgsql-sql-owner@postgresql.org
Subject: Re: having trouble w/ having clause...
Date: Mon, 13 May 2002 08:35:19 +0200
Message-ID: <OF83111100.01FEDB23-ONC1256BB8.0024281D@ebewe.co.at> (raw)
On 08.05.2002 22:58:59 pgsql-sql-owner wrote:
>Hi all,
>
>This is a simple question, but for the life of me, I can't see what is
wrong
>with this query:
>
>select host,slot,port,count(mac) as d from cam group by host,slot,port
having
>d>1;
try:
select host,slot,port,count(mac) as d from cam group by host,slot,port
having count(mac) >1;
W
>
>I'm running 7.2.
>
>Thanx in advance,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Wolfgang.Fuertbauer@ebewe.com, jdiehl@sandia.gov, pgsql-sql-owner@postgresql.org
Subject: Re: having trouble w/ having clause...
In-Reply-To: <OF83111100.01FEDB23-ONC1256BB8.0024281D@ebewe.co.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox