KnowCardSAP HANA SQLScript · SQLScript Basics: Syntax, Variables & NULL
What is the DUMMY table, and why is it handy in the SQL console?
Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.
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?
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?
Relational operators normally return TRUE or FALSE. What third result do they return, and when?
Start learning today
Free to start — download the app or use it in your browser.