Posted by no.mail.pls on 03/02/06 06:23

Hi Steve,

Thanks for the reply. It works.
i am aware that this is not a sql group, but i beg your indulgence, as i am
quite sure that you guys will respond,
because i believe that most folks who use PHP
will also be using mysql.

is that correct?

cheers
"Steve" <ThisOne@Aint.Valid> wrote in message
news:pan.2006.03.02.04.04.02.810758@Aint.Valid...
> On Thu, 02 Mar 2006 11:41:12 +0800, dottty wrote:
>
>> Hi,
>> i have a table that has the following fields:
>> id, name, dept, pay
>> 1, John, Sales, 4000
>> 2, Peter, HR, 5000
>> etc.
>>
>> How do i count how many people there are in each dept with an sql query?
>>
>> I find this surprisingly difficult, given the fact that i can sum the
>> total
>> pay for each dept by using:
>> $query="
>> Select sum(if (dept='HR', pay, 0)) as hrpay, ......
>> ";
>>
>> TIA
>
> Blimey, is that sql? Given the standard rider about this *not* being a
> mysql support group, something like the (untested) suggestion below might
> help:
>
> select dept, count(*), sum(pay) from ... group by dept, order by dept;
>
> Steve
>

[Back to original message]