What does the CASE expression return when no WHEN condition matches and no ELSE is provided?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What does the CASE expression return when no WHEN condition matches and no ELSE is provided?

Key points

  • NULL is the default result when no conditions are met
  • The absence of an ELSE clause leads to NULL as the result
  • This behavior helps handle unexpected scenarios in SQL queries

Ready to go further?

Start full exam Practice more questions

Related questions