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
-
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