How to write triggers to increment or decrement the number of employees

Curious Capuchin answered on November 14, 2021 Popularity 2/10 Helpfulness 1/10

Comment

CREATE TRIGGER NEW_HIRED
     AFTER INSERT ON EMPLOYEE
     FOR EACH ROW
     UPDATE COMPANY_STATS SET NBEMP = NBEMP + 1

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.ibm.com

Tags: decrement increment sql triggers

Link to this answer
Share Copy Link

Contributed on Nov 14 2021

Curious Capuchin

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.