Hi,
Please help what is wrong with this simple query "SELECT COUNT(key_agent) total
FROM agents_consolidated WHERE total = 180"
Thanks.
Willy Mularto
F300HD+MR18DE (NLC1725)
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
> F300H
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 t
Hi ,
count() function is a group function so use group by clause in your select
statement if you are selecting more than one column data..
here is some sample query related to help you,
select count(*) from trndisburse:
output:1467
select count(*),pkdisburseid from trndisburse_TMP m Group
Red carpet for you Using shared memory! last one was Monty while
developing MySQL 3.x!!!
Sorry Siva,
A bit of fun about MySQL on windows shared-memory protocol :)
I have no experience on Shared Memory protocol and as me I think 99.999% of
MySQL users.
I think it would be way more appropriate
