Scribd
Upload
31 views1 page

BonusUpdate (Script)

Uploaded by

chanduvenu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
31 views1 page

BonusUpdate (Script)

Uploaded by

chanduvenu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

--STATEMENT NUMBER 1

UPDATE employee
SET bonus =
CASE
WHEN salary < 3000
THEN 100
WHEN salary BETWEEN 3000 AND 4000
THEN 200
WHEN salary BETWEEN 4001 AND 4900
THEN 300
END;

--STATEMENT NUMBER 2
commit;

You might also like