List:General Discussion« Previous MessageNext Message »
From:Willy Mularto Date:April 14 2012 10:37am
Subject:Re: Simple Query Question
View as plain text  
Hi many thanks for the help :)



On Apr 14, 2012, at 6:21 PM, Stefan Kuhn wrote:

> 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)
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 

Willy Mularto
F300HD+MR18DE (NLC1725)









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