This content has been marked as final. Show 3 replies
count (field) not selects null values for filed
Excerpt from Oracle Documentation:1 person found this helpful
All aggregate functions except COUNT(*), GROUPING, and GROUPING_ID ignore nulls.
For More information, read SQL Aggregate Function (Scroll till Aggregate Functions)
Rahul India wrote:Basically, yes.
... so do all group functions ignore null?
COUNT (*), as you showed, does not ignore NULLs. It includes rows even when all columns are NULL.
Would you say GROUPING is a "group function"? (I would.) Would you say GROUPING ignores NULLs? (I wouldn't.)
How about FIRST and LAST?