IF THEN ELSE statement

Applies to: Databricks SQL Databricks Runtime 16.3 and above

Executes lists of statements based on the first condition that evaluates to true.

This statement may only be used within a compound statement.

IF condition  THEN { stmt ; } [...]
  [ { ELSEIF condition THEN { stmt ; } [...] } [...] ]
  [ ELSE { elseStmt ; } [...] ]
  END IF

• condition

  Any expression evaluating to a BOOLEAN.

• stmt

  A SQL statement to execute if the condition is true.

• elseStmt

  A SQL statement to execute if no condition is true. That is all condition are false or null.

> BEGIN
    DECLARE choice DOUBLE DEFAULT 3.9;
    DECLARE result STRING;
    IF choice < 2 THEN
      VALUES ('one fish');
    ELSEIF choice < 3 THEN
      VALUES ('two fish');
    ELSEIF choice < 4 THEN
      VALUES ('red fish');
    ELSEIF choice < 5 OR choice IS NULL THEN
      VALUES ('blue fish');
    ELSE
      VALUES ('no fish');
    END IF;
  END;
 red fish

• SQL Scripting
• CASE Statement
• Compound Statement
• FOR Statement