sql

Definition

COALESCE (SQL)

COALESCE is a standard SQL function that returns the first non-null argument.

Examples:

  • COALESCE(null, null, foo) -> foo
  • COALESCE(foo, null, null) -> foo
  • COALESCE(null, null, foo, null, null) -> foo