having trouble w/ having clause...
Mike Diehl <jdiehl@sandia.gov>
From: Mike Diehl <jdiehl@sandia.gov>
To: pgsql-sql@postgresql.org
Date: 2002-05-08T20:58:59Z
Lists: pgsql-general, pgsql-sql
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; I'm running 7.2. Thanx in advance, -- Mike Diehl Network Tools Devl. Sandia Labs (505) 284-3137