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

SQL Fundamentals Easy

SQL Fundamentals — Easy

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

Key points

  • COALESCE returns the first non-NULL value
  • It checks arguments in order from left to right
  • Useful for handling NULL values in SQL queries

Ready to go further?

Related questions