Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:loesungen:l03 [2024/10/01 10:48] – angelegt vdemir
+++ modul:m290:learningunits:lu07:loesungen:l03 [2024/10/17 12:44] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07.S03 - UPDATE ======
+====== LU08.S03 - UPDATE ======
-===== A: Update with OR =====
+===== A: Basic Update =====
+The employee ‘Laura Clark’ got divorced and therefore took her maiden name. Update her data record in the table.
+  Update employees
+  SET surname = 'Suter'
+  WHERE employee_ID = 8;
+{{:modul:m290:learningunits:lu07:loesungen:lu07.s03a2.png?500|}}
+===== B: Update with OR =====
 As a company policy the attribute 'sex' is not required anymore and is to be emptied. Formulate the corresponding SQL statement that deletes all content from that column.
@@ Zeile 12: / Zeile 21: @@
 {{:modul:m290:learningunits:lu07:aufgaben:lu07.s03a.png?800|}}
-===== B: Update with AND =?===
+===== C: Update with AND =?===
 The performance of our company's IT department was outstanding last year, resulting in a pay rise to 70'000 for all IT employees earning less than CHF 70,000. Create a DML update command that covers the requirements.