Re: possible bug in sum() function

[Gerald Clark]

bferrell@stripped wrote:

> We keep a timecard database and I was just asked how much time had been charged to a
> particular project code.  No problem says I and did the following:
> 
> select sum(worktime) from timecard where tcacct=project;
> 
> The answer came back 182.  Then I was asked who had spent time on the project.
> 
> the query was:
> 
> select sum(worktime),user from timecard where tcacct=project group by user;
> 
> the answer was:
> 
> 8.00    user1
> 14.00   user2
> 160.00  user 3
> 
> Now, where I went to school, this adds up to 184!
> 
> Suggestions?
> 
> 

Pick a better school?

-- 
Gerald L. Clark
gerald_clark@stripped