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 exclude NULL values from NTILE function?

bda29e67-e262-4820-90b7-c23eed14f0fdSep 6 2016 — edited Sep 7 2016

Hi all,

I want to use ntile function over a column that can have null values and I need it to ignore the null rows when calculating the ntile.

So I wonder how does NTILE function process NULL value? Does it ignore null values or do I need to use any key words for that?

Thanks,

Alex
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2016
Added on Sep 6 2016
4 comments
4,559 views