ELSE Value

ELSE supplies the no-match result.

highlighted = computed this step

ELSE is the value used when no WHEN branch is TRUE.

\text{ELSE fallback}

Read ELSE rows

The ELSE value is used for 2 rows.

\text{ELSE rows}=2

CASE-expression examples are tiny finite row transforms with SQL-style TRUE/FALSE/UNKNOWN logic; SQL dialect completeness, type coercion, optimizer behavior, indexing, and product claims are out of scope.

One fallback value

Both FALSE fall-through and UNKNOWN fall-through use the same ELSE value here.

\text{shared fallback}

Summary

ELSE makes the no-match case explicit.

\text{explicit fallback}