When using the SUM() function in DB2, NULL values in the column are ________ in the calculation.

  • Counted
  • Ignored
  • Treated as Zero
  • Excluded
The correct option is "Ignored". When using the SUM() function in DB2, NULL values in the column are ignored in the calculation. Only non-NULL values are summed up. It's essential to be aware of this behavior when performing calculations with SUM(). 
Add your answer
Loading...

Leave a comment

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