IF THEN ELSE

IF THEN ELSE construct is a simplified version of CASE statement:

SELECT IF condition THEN expression ELSE expression END

is equivalent to

SELECT CASE WHEN condition THEN expression ELSE expression END

For the detailed discussion of the semantics see CASE statement .

Syntax

SELECT IF … THEN … ELSE … END
SELECT IF condition THEN number ELSE number END
SELECT IF condition THEN arithmetic_operation ELSE arithmetic_operation END

Examples

SELECT IF SUM({fact/amount})>= AVG({fact/amount}) THEN 10 ELSE 0 END
SELECT IF SUM({fact/duration}) - AVG({fact/duration}) > 2000  THEN 0 ELSE 1 END
SELECT IF AVG({fact/probability}) > 0.5 THEN SUM({fact/amount}) * 10 ELSE SUM({fact/amount}) / 10 END