New: Intelligent Flashcards spaced-repetition decks for every topic, built to make things actually stick.
When a searched CASE WHEN ... THEN ... END expression has several WHEN clauses that could match the same row, which result is returned?
CASE WHEN ... THEN ... END
The last WHEN whose condition is true wins, similar to a CSS specificity cascade
The result of the first WHEN whose condition is true; later WHEN clauses are not evaluated
All matching THEN results are concatenated together as a single output value