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!

why CORR return NULL....

benleg1Jul 12 2002
Why CORR return NULL....

I'm using the CORR () function.

select options.NAME_OPT,
(options.PER_OPT / 12) as pecr,
(count(draws.ID_DRW) / 9) as nbr,
corr(options.PER_OPT, count(draws.ID_DRW))
over(order by options.NAME_OPT) as cor
from options,
draws
where options.ID_OPT = draws.ID_OPT
and options.ID_SIT = 1
and options.PER_OPT is not null
group by options.NAME_OPT,
options.PER_OPT


But the value return is always NULL

Anyone could help me

Thanks for your help

Benoit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2002
Added on Jul 12 2002
1 comment
421 views