LEAVE statement

Applies to: Databricks SQL Databricks Runtime 16.3 and above

Preview

This feature is in Public Preview.

Terminates the execution of an iteration of a looping statement and exits the loop.

This statement may only be used within a compound statement.

Syntax

LEAVE label

Parameters

• label

  The label identifies a statement to leave that directly or indirectly contains the LEAVE statement.

Examples

SQL

-- sum up all odd numbers from 1 through 10
-- Iterate over even numbers and leave the loop after 10 has been reached.
> BEGIN
    DECLARE sum INT DEFAULT 0;
    DECLARE num INT DEFAULT 0;
    sumNumbers: LOOP
      SET num = num + 1;
      IF num > 10 THEN
        LEAVE sumNumbers;
      END IF;
      IF num % 2 = 0 THEN
        ITERATE sumNumbers;
      END IF;
      SET sum = sum + num;
    END LOOP sumNumbers;
    VALUES (sum);
  END;
25

Related articles

• SQL Scripting
• CASE Statement
• Compound Statement
• FOR Statement
• LOOP Statement
• WHILE Statement
• IF Statement
• ITERATE Statement