NULL is not determinate value and is not counted when the COUNT function

As we can see when you supply NULL explicitly to COUNT it will produce 0, even if the query was executed against dual table. In plain words, you can translate this operation as “nothing to count” since NULL is exactly void and/or nothing.

Leave a comment

Your email address will not be published. Required fields are marked *