471,092 Members | 1,525 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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

jt
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?
Jul 19 '05 #1
1 3698
look at nvl function

"jt" <ju**********@yahoo.com> wrote in message
news:6f**************************@posting.google.c om...
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?

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Boefje | last post: by
26 posts views Thread by Agoston Bejo | last post: by
3 posts views Thread by iStrain | last post: by
5 posts views Thread by William Wisnieski | last post: by
3 posts views Thread by deejayquai | last post: by
2 posts views Thread by andrey.vul | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.