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

Home -> Community -> Mailing Lists -> Oracle-L -> Grouping NULL values

Grouping NULL values

From: Robert Sisk <rsisk_at_SCTCORP.COM>
Date: Tue, 2 Jan 1996 14:57:34 -0500
Message-Id: <9601022003.AA05696@alice.jcc.com>


Does anyone have any nifty work arounds for grouping null values?

ex/

   Select nvl(column1, 0), count(column1) from table1

       group by column1;

If the values in the database are 1,2,3 and NULL it returns

column1 Count(column1)
------- --------------

1              7
3              4
3             12
0              0   I know there are null values in the table....

Thanks in advance....



Robert
|===========================================================|

| Robert Sisk Phone: (803) 935-8136 |
| SCT Utility Systems Email: rsisk_at_sctcorp.com |
|===========================================================|
Received on Tue Jan 02 1996 - 15:03:15 CST

Original text of this message

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