Tag: aggregate

Oracle Pro Members Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here