子句

以例子学习with： 1.with 2.–查询部门和部门的总薪水 3. dept_costs as ( 4. select d.department_name,sum(e.salary) dept_total 5. from departments d,employees e 6. wh…