ReferenceSQL FunctionsConditionVersion: Latest-4.1Copy as MarkdownView as Markdown/docs/sql-reference/sql-functions/condition-functions.mdOpen in ClaudeOpen in ChatGPTBrowse all docs as Markdown/llms.txtCondition ποΈ caseCASE is a conditional expression.ποΈ coalesceReturns the first non-NULL expression among the input parameters.ποΈ ifIf expr1 evaluates to TRUE, returns expr2.ποΈ ifnullIf expr1 is NULL, returns expr2.ποΈ nullifReturns NULL if expr1 is equal to expr2.