Re: Query question.

Hi Richard,

Richard Reina wrote:
> I have a database table paycheck like this.
> empno, date, gross, fed_with
> 1234 "2007-09-01" 1153.85 108.26
> 1323 "2007-09-01" 461.54 83.08
> 1289 "2007-09-01" 1153.85 94.41
> 1234 "2007-09-15" 1153.85 108.26
> 1323 "2007-09-15" 491.94 87.18
> 1289 "2007-09-15" 1153.85 94.41
>
>
> I can easily do a query like this
>
> select (SUM(gross) * .153) + SUM(fed_with) FROM paycheck where
> DATE="2007-09-01";
>
> But then I have to do a query for each pay date in the pay period.
>
> Accordingly, what would be really useful on a day like today would be to be
> able to do a query like the following:
>
> select (SUM(gross) * .153) + SUM(fed_with) FROM paycheck where DATE IS
> distinct;
>
> Does anyone know how to do this?

it seems you want to use "group by":
SELECT (SUM(gross) * .153) + SUM(fed_with) FROM paycheck GROUP BY date;

See here:
http://dev.mysql.com/doc/refman/5.0/en/select.html http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

HTH,
Joerg

-- 
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com