Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu07:aufgaben:04 [2024/10/01 11:58] – vdemir | modul:m290:learningunits:lu07:aufgaben:04 [2024/10/17 13:47] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ===== Requirements | ===== 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. | 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 | + | ==== A: Delete |
| Sarah Johnson has left the company and is therefore to be deleted from the table. Formulate the according DML DELETE statement. | 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: | ||
| {{: | {{: | ||
| - | ==== B: Delete | + | ==== B: Delete |
| 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. | 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. | ||
| Zeile 50: | Zeile 50: | ||
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||
| - | | be about time | ist höchste Zeit | | + | | ... | ... | |
| - | | subsequently | | + | |
| ---- | ---- | ||
| [[https:// | [[https:// | ||