Netezza Case Statement and its Usage with Examples
The Netezza CASE statement chooses value from a sequence of conditions, and executes a corresponding statement. The CASE statement evaluates a single expression and compares it against several potential available values, or evaluates multiple Boolean expressions and chooses the first one that is TRUE. Netezza Case Statement Syntax Searched form: CASE WHEN <search-condition-1> THEN <result-1> WHEN <search-condition-2> THEN <result-2> ... WHEN <search-condition-n> THEN <result-n> ELSE <default-result> END Search conditions can be arbitrarily complex and results can be expressions. Value form: CASE <test-value> WHEN <comparand-value-1> THEN <result-1> WHEN <comparand-value-2> THEN <result-2>…