SQL Commands in SAP Datasphere: Unterschied zwischen den Versionen
Aus MattWiki
Matt (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „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:<syntaxhighlight lang="sql" line="1"> CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END; </syntaxhighlight> Kategorie:SAP Kategorie:SQL Kategorie:HANA“) |
(kein Unterschied)
|
Aktuelle Version vom 7. Juni 2024, 17:49 Uhr
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;