select employees.employee_id,
employees.salary,
employees.department_id,
avg_tmp.avgsalary
from employees
left outer join (select department_id, avg(salary) as avgsalary
from employees
group by department_id) avg_tmp
on employees.department_id = avg_tmp.department_id
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024