Re: How do I rename null values found in GROUP BY column?

Thanks "nobody". NVL is the function I was looking for!

"nobody" <nobody_at_nowhere.com> wrote in message news:<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 Tue Aug 26 2003 - 04:50:13 CEST