SQL Commands in SAP Datasphere

This article explains SQL commands and control structures used in SAP Datasphere for various use cases.

Control Structures

If-Then-Else

Is represented in SQL with CASE-WHEN-ELSE:

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END;