List:General Discussion« Previous MessageNext Message »
From:Stefan Kuhn Date:April 14 2012 11:21am
Subject:Re: Simple Query Question
View as plain text  
On Saturday 14 April 2012 09:51:11 Willy Mularto wrote:
> Hi,
> Please help what is wrong with this simple query "SELECT COUNT(key_agent)
> total FROM agents_consolidated  WHERE total = 180" Thanks.
You need to use having instead of where, see the documentation.
Stefan
>
>
>
> Willy Mularto
> F300HD+MR18DE (NLC1725)


Thread
Simple Query QuestionWilly Mularto14 Apr
  • Re: Simple Query QuestionStefan Kuhn14 Apr
    • Re: Simple Query QuestionWilly Mularto14 Apr