What does the COALESCE function return?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What does the COALESCE function return?

Key points

  • COALESCE returns the first non-NULL value
  • It evaluates arguments from left to right
  • If all arguments are NULL, COALESCE will return NULL

Ready to go further?

Related questions