Below Query for update NEW_SALARY column using Joins:
Below Query for update NEW_SALARY column using Joins:
UPDATE update_sal sal
SET sal.new_sal = (SELECT sal.salary + NVL(sr.commission,500)
FROM salary_record sr
WHERE sal.department_id = sr.department_id)
WHERE EXISTS (SELECT 1
FROM salary_record sr
WHERE sal.department_id = sr.department_id);
No comments:
Post a Comment