Oracle SQL - Group Functions and Null Values

Introduction

The following table lists the Behavior of Group Functions and Null Values

Set XSUM(X) MIN(X) AVG(X) MAX(X)
{1,2,3,NULL} 6 1 2 3
{1,2,3,0}6 0 1.5 3
{1,2,3,2}8 1 2 3

The SUM function does not make any distinction between {1,2,3,NULL} and {1,2,3,0}.

The MIN and AVG functions don't make any distinction between {1,2,3,NULL} and {1,2,3,2}.

The MAX function gives the same result on all three sets.

Related Topic