Abwärtskompatibilität 3
  • CREATE VIEW hohes_gehalt AS
    SELECT * FROM gehalt WHERE gehalt > 3500;

  • UPDATE gehalt g
    SET summe = 1.1 * summe
    WHERE g.ano = (SELECT a.ano
    FROM angestellte a WHERE a.name = 'Theresa');

  • COMMIT;