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:// |