|
|
Posted by Steve on 03/02/06 06:04
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
Navigation:
[Reply to this message]
|