Hi experts,

IF the name of NODE N02 is not null (Cherry), then select NAME of N02, it is one row :
Cherry
IF the name of NODE N02 is null(#) , then select NAME of N23 and N24, there are two rows :
Alpha
Tom
How to achieve this using SAP HANA SQL ?
Tks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.