Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:aufgaben:04 [2024/10/01 11:47] – angelegt vdemir
+++ modul:m290:learningunits:lu07:aufgaben:04 [2024/10/17 13:47] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07.A04 - DELETE ======
+====== LU08.A04 - DELETE ======
 ===== Requirements  =====
@@ Zeile 11: / Zeile 11: @@
 After selecting data in assignment A1 and updating it in A2, it is about time to turn to how to delete data from the table.
-==== A: Delete on one row ====
+==== A: Delete of one row ====
 Sarah Johnson has left the company and is therefore to be deleted from the table. Formulate the according DML DELETE statement.
@@ Zeile 25: / Zeile 25: @@
 {{:modul:m290:learningunits:lu07:aufgaben:lu07.s04a.png?600|}}
-==== B: Delete on multiple rows ====
+==== B: Delete of multiple rows ====
 It is common, that we retire when reaching a certain age. Remove all date from individuals who are older than 60 from the employees table.
 Hint: Before performing the deletion, make sure that you got the right resultset.
+Content of the table before deleting the concerned resultset:
-SELECT * FROM employees
+{{:modul:m290:learningunits:lu07:aufgaben:lu07.s04b.png?600|}}
-WHERE birthdate > '1994-00-00';
+  SELECT * FROM employees
+  WHERE birthdate < '1964-01-01';
+  DELETE FROM employees
+  WHERE birthdate < '1964-01-01';
+The result is visible in the next image below:
+{{:modul:m290:learningunits:lu07:aufgaben:lu07.s04c.png?600|}}
 ===== Solution =====
-[[modul:m290:learningunits:lu07:loesungen:l03|Lösung]]
+[[modul:m290:learningunits:lu07:loesungen:l04|Lösung]]
 ===== Vocabulary =====
 ^ English ^ German ^
-| be about time | ist höchste Zeit |
+| ... | ... |
-| subsequently |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir