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
F300HD+MR18DE
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
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
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