I'm replying to the list because I got sooooo many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is very
red.
Sinisa Milivojevic wrote:
> [EMAIL PROTECTED] writes:
> > 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?
> >
> >
>
> Sorry, but you have gone to the wrong school.
>
> 8 + 14 + 160 = 182
>
> When in doubt, use a calculator to see the correct result.
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
