COALESCE (A,B)is equivalent to?

technology databases

  1. CASE WHEN B IS NOT NULL THEN A ELSE B

  2. CASE WHEN A IS NOT NULL THEN A ELSE B

  3. CASE WHEN A IS NOT NULL THEN B ELSE A

  4. CASE WHEN A IS NOT NULL THEN A ELSE A

Show answer
Correct Option: B

Find more quizzes: