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