SAP HANA SQLScript · SQLScript Basics: Syntax, Variables & NULL

What does this return with str? ``` SELECT 5 + NULL AS a, NULL || 'str' AS b FROM dummy; ```

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in SQLScript Basics: Syntax, Variables & NULL

You want "first non-NULL of these values, else a fallback." COALESCE vs IFNULL — which, and how do they differ?

What is the DUMMY table, and why is it handy in the SQL console?

You must assign an empty but correctly-structured table (e.g. an AMDP ERRORTAB) or activation fails. How does the DUMMY trick do it?

What are the three ways to give a local table variable its type in a DECLARE?

Row 5 of test_null has NAME = NULL. Which of these two SELECTs returns row 5? ``` WHERE name LIKE 'P%' -- or -- WHERE name NOT LIKE 'P%' ```

You want a column literally named STATUS. It seems to work sometimes and break others. What's going on, and how do you check?

Start learning today

Free to start — download the app or use it in your browser.