如何在单个请求中更新整个列

普通人力资源计划,如何用单个请求更新整列?

update depts 
set tot_dept_sal = (select sum(e.salary)
                    from departments d, employees e 
                    where d.DEPARTMENT_ID=e.DEPARTMENT_ID
                    group by d.DEPARTMENT_NAME);