Query question.

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?

Thanks for the help.

Richard Received on Wed Oct 31 10:12:01 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek