Re: Group by Month/Year and Product with sum of quantity including null records
From: Sharkie <sharkdba_at_yahoo.com>
Date: 30 Mar 2004 14:49:07 -0800
Message-ID: <423b5ab1.0403301449.4ed30d6_at_posting.google.com>
Date: 30 Mar 2004 14:49:07 -0800
Message-ID: <423b5ab1.0403301449.4ed30d6_at_posting.google.com>
ed.prochak_at_magicinterface.com (Ed prochak) wrote in message news:<4b5394b2.0403171131.54b7ab0e_at_posting.google.com>...
> Lastly, look up NULLs and sorting in the ORACLE manuals. (you'll find
> they are sorted last! always!)
unless there's a "nulls first" clause, ie:
order by <some field> nulls first; Received on Wed Mar 31 2004 - 00:49:07 CEST