KnowCardSAP HANA SQLScript · Declarative Queries: SELECT, Joins & Filtering
What breaks if the subquery behind an IN predicate selects two columns?
Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.
More in Declarative Queries: SELECT, Joins & Filtering
What exactly does SELECT DISTINCT country, city deduplicate?
IN and EXISTS can express the same filter. What does each actually check?
In CONTAINS((firstname,lastname,email),'andy',FUZZY(0.3)), what does the 0.3 do and what's the default?
INTERSECT and EXCEPT are rare in practice. What join/predicate replaces each, and what must the replacement add?
Find tables literally named P then _ ...
Why is ESCAPE needed here?
```
WHERE table_name
LIKE 'P$_%' ESCAPE '$'
```
Some rows have firstname NULL.
What does query 2 return?
```
-- 1
WHERE firstname IS NULL
-- 2
WHERE firstname = NULL
```
Start learning today
Free to start — download the app or use it in your browser.