USE OF CASE STATEMENT IN HANA SQL SCRIPT-2

light111Case Statement use in HANA SQL Script


In one of the last post  Use of CASE Statement in HANA SQL Script    we know a simple use of CASE statement . 

Here a slightly different use of CASE statement in SQL Script. Below as highlighted we can directly put a condition in the WHEN part and if the condition is true, hence forth the THEN part is executed. The condition in the when can be a complex one.

1

Debug Details-

2

Now we can put a little complex condition in the WHEN clause.

3

Debug Details-

4


 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s