Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Get ZERO and Non-ZERO Values in rowcount using Group by?

GQApr 2 2011 — edited Apr 2 2011
Dear All,

How can I get Non-ZERO and ZERO row count values in SQL using Group by? I can get non-zero values but when I want NULL should be returned to non-zero values it is ignoring ZERO values in output?

Any hint?

Thanks
GQ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2011
Added on Apr 2 2011
1 comment
1,271 views