Glossary: SQL Beyond the Basics
CASE expression
Also written: CASE, CASE WHEN
A value chosen by testing conditions from the top and using the result of the first true one. If none are true and there's no ELSE, the result is NULL.
Glossary: SQL Beyond the Basics
Also written: CASE, CASE WHEN
A value chosen by testing conditions from the top and using the result of the first true one. If none are true and there's no ELSE, the result is NULL.