What does the COALESCE(a, b, c) function return?

SQL Data Analyst Medium

SQL Data Analyst — Medium

What does the COALESCE(a, b, c) function return?

Key points

  • COALESCE() returns the first non-NULL value.
  • It is useful for replacing NULL values with actual data.
  • The function stops evaluating arguments once a non-NULL value is found.

Ready to go further?

Start full exam Practice more questions

Related questions