COALESCE is defined as shorthand for the following SQL CASE expression: CASE WHEN value1 IS NOT NULL THEN value1 WHEN value2 IS NOT NULL THEN value2 WHEN value3 IS NOT NULL THEN value3 ...
COALESCE визначена як умовне позначення для наступного SQL CASE виразу: CASE WHEN value1 IS NOT NULL THEN value1 WHEN value2 IS NOT NULL THEN value2 WHEN value3 IS NOT NULL THEN value3 ...