What is the behavior of the STDDEV() function in DB2 when applied to a column with NULL values?

  • It returns NULL
  • It returns 0
  • It returns 1
  • It returns error
The correct option is 1. The STDDEV() function in DB2 returns NULL when applied to a column with NULL values. It does not include NULL values in the calculation of standard deviation. 
Add your answer
Loading...

Leave a comment

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