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!
Hi, I have one query as below select COUNT(*) OVER (PARTITION BY question_id) from t1 where survey_id=4; question: table t1 has null values and query counting null values also. how can I ignore nulls in count analytical function.
Thanks in Advance,