Re: Need help with monstrous query migrated from sql server

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Wed, 19 Apr 2006 18:58:47 GMT
Message-ID: <IxzGpz.KBB@igsrsparc2.er.usgs.gov>

> You wrote: "HAVING SUM(hboksaldo) <> 0"
> Can sums ever be less than zero?

Of course they can....but you knew that....

Sum up these numbers:

  1
-5
  2
-6

---

-8 <= Total = Sum

Cheers!
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Apr 19 2006 - 13:58:47 CDT