Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Grouping NULL values
ex/
Select nvl(column1, 0), count(column1) from table1
group by column1;
Does anyone have any nifty work arounds for grouping null values?
If the values in the database are 1,2,3 and NULL it returns
column1 Count(column1)
Thanks in advance....
------- --------------
1 7
3 4
3 12
0 0 I know there are null values in the table....
Robert
|===========================================================|Received on Tue Jan 02 1996 - 15:03:15 CST
| Robert Sisk Phone: (803) 935-8136 |
| SCT Utility Systems Email: rsisk_at_sctcorp.com |
|===========================================================|
![]() |
![]() |