Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Left Outer Join and totals

Re: Oracle Left Outer Join and totals

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 23 May 2006 06:50:15 GMT
Message-ID: <1148367014.883406@proxy.dienste.wien.at> 





bbcrock_at_gmail.com wrote:


> Was hung up on the count(*)- that caused the bad results.  running the

> count on report_id solved it.




Yes, because count(*) always counts, while count(report_id) will
omit NULLs.



Yours,


Laurenz Albe
Received on Tue May 23 2006 - 01:50:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US