Re: How do I rename null values found in GROUP BY column?
From: nobody <nobody_at_nowhere.com>
Date: Mon, 25 Aug 2003 15:57:37 GMT
Message-ID: <Rlq2b.264037$4UE.98001_at_news01.bloor.is.net.cable.rogers.com>
Date: Mon, 25 Aug 2003 15:57:37 GMT
Message-ID: <Rlq2b.264037$4UE.98001_at_news01.bloor.is.net.cable.rogers.com>
look at nvl function
"jt" <judiphuongtu_at_yahoo.com> wrote in message
news:6f38222f.0308250751.27404fdb_at_posting.google.com...
> Here's a sample result from the following statement:
>
> select dept, sum(cost)
> from dept
> group by dept;
>
> dept sum(cost)
> ---- --------
> null 1000
> 200 20
> 300 100
>
> Is there a way I can rename the null value to some other value?
Received on Mon Aug 25 2003 - 17:57:37 CEST