QuestionQ14

Creating Field Aliases and Calculated Fields

Which statement about the coalesce function is correct?

  • A It can take only a single argument.
  • B It can take a maximum of two arguments.
  • C It can be used to create a new field in the results set.
  • D It can return null or non-null values.
Explanation

The coalesce function can be used in an eval expression to assign a derived field in the results set. It evaluates its arguments in order and returns the first non-null value.

Community Discussion

No comments yet. Be the first to start the discussion!