Re: having trouble w/ having clause...

On Wednesday 08 May 2002 22:58, Mike Diehl 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

See:

http://www.postgresql.org/idocs/index.php?sql-select.html

"output_name

 Specifies another name for an output column using the AS clause. This name is    
 primarily used to label the column for display. It can also be used to refer
 to the column's value in ORDER BY and GROUP BY clauses. But the output_name 
 cannot be used in the WHERE or HAVING clauses; write out the expression 
 instead."

HTH

Ian Barwick