SAP HANA SQLScript · Write Access to the Database (DML)

When UPSERT uses a WHERE clause instead of WITH PRIMARY KEY, what must that WHERE still contain?

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 Write Access to the Database (DML)

In SAP HANA, how do the REPLACE and UPSERT statements differ?

In UPSERT table_1 SELECT ... FROM table_1 WHERE key2 = 2, what does the WHERE apply to?

What can MERGE INTO do that UPSERT cannot, and from which HANA version is it available?

Which SAP Note recommends MERGE INTO over UPDATE ... FROM, and what happens if you omit one MERGE branch?

You DELETE FROM a table, realize it was wrong, and run ROLLBACK. Does the data come back?

You TRUNCATE TABLE, realize it was wrong, and run ROLLBACK. Does the data come back?

Start learning today

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