When must you use a searched CASE (CASE WHEN ...) instead of a simple CASE (CASE WHEN ...)?

SAP HANA SQLScript · Declarative Queries: SELECT, Joins & Filtering

When must you use a searched CASE (CASE WHEN <cond> ...) instead of a simple CASE (CASE <expr> WHEN <val> ...)?

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 Declarative Queries: SELECT, Joins & Filtering

What exactly does SELECT DISTINCT country, city deduplicate?

What breaks if the subquery behind an IN predicate selects two columns?

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 '$' ```

Start learning today

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