NULLs and Average

NULLs and Average Aggregate functions, such as MAX, MIN, AGR, and SUM ignore NULLs. That may be a problem if you want to aggregate all the rows, not just those with non-NULL values for the column of interest. To solve this problem, you can use the NVL function. Read on to learn how. For the article sample, you’ll need to…