Multiple choice technology

Which SQL function lets you substitute a value when a null value is returned from from a row ?

  1. NVL

  2. COUNT

  3. CASE

  4. MAX
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

NVL (or COALESCE in standard SQL) substitutes a replacement value when NULL is encountered. NVL(expr, replacement) returns 'replacement' if 'expr' is NULL, otherwise returns 'expr'. COUNT counts rows, CASE is conditional logic, and MAX finds maximum values - none of these handle NULL substitution.

Keep practicing — related questions