Skip to Main Content

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!

need to display 0 when null values of count

user575115Jan 11 2010 — edited Jan 12 2010
Hi,
Below one is my query,when count isnull then i need to return 0(zero) can some one help

SELECT COUNT(*) TOT_STUD_ITEM_SS , 
                                                            Count(Case When RESPONSE_IS_CORRECT = 1 Then 1 End)  As TOT_STUD_CORR_ANS_ITEM_SS
                                                             FROM PSYCHOMETRIC_ITEM_STAT_OPN A, VW_SCALE_SCORE_CONFIG B
                                                             WHERE    SS_ITEM_STAT_OPN.ITEM_ID=TV_SS_ITEM_STAT_OPN(LN_SSI_OPN).ITEM_ID
                                                             AND     (SS_ITEM_STAT_OPN.BEGIN_VALUE=TV_SS_ITEM_STAT_OPN(LN_SSI_OPN).BEGIN_VALUE
                                                             AND    SS_ITEM_STAT_OPN.END_VALUE=TV_SS_ITEM_STAT_OPN(LN_SSI_OPN).END_VALUE)
                                                              AND     SS_ITEM_STAT_OPN.ITEM_ID = A.ITEM_ID 
                                                              AND SS_ITEM_STAT_OPN.END_VALUE = B.END_VALUE
                                                              AND ROUND(A.SCALE_SCORE) > BEGIN_VALUE
                                                              AND ROUND(A.SCALE_SCORE) <= END_VALUE
                                                              AND CONDITION_COLUMN= 'SCALE_SCORE'
                                                              GROUP BY ITEM_ID,END_VALUE
and i tried like below but it's still returning null only
SELECT nvl(COUNT(*) ,0) TOT_STUD_ITEM_SS , 
                                                             nvl(Count(Case When RESPONSE_IS_CORRECT = 1 Then 1 End),0) As TOT_STUD_CORR_ANS_ITEM_SS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2010
Added on Jan 11 2010
12 comments
23,640 views