Modifikation: Lilian bekommt am 1.4.1995 eine 5% Gehaltserhöhung.
Level 2 - SQL-Statement:
- UPDATE gehalt
SET summe = 1.05 * summe
WHERE ano = (SELECT g.ano
FROM gehalt AS g, angestellte AS a
WHERE name = 'Lilian' AND g.ano = a.ano;
- COMMIT;
- Tabelle gehalt:
ano |
summe |
| VALID |
6542 |
3200 |
|
[1995-02-01 - 9999-12-31) |
3463 |
3400 |
|
[1995-02-02 - 1995-04-01) |
3463 |
3570 |
|
[1995-04-01 - 9999-12-31) |