Update statement with Join in SQL

Below Query for update NEW_SALARY column using Joins:


  1. UPDATE update_sal sal

  2. 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);

Share:

No comments:

Post a Comment

Popular Posts

Search This Blog

Powered by Blogger.

Blog Archive

Service Support

Need our help to Learn or Post New Concepts Contact me

Blog Archive

Recent Posts

Service Support

Need our help to Learn or Post New Concepts Contact me