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,