Show for each employee, their current salary and their current manager’s current salary

Viewed 18

Please advise, this code giving me name+salary+ managerid and i dont know how to get manager salary

SELECT *
FROM employees.employees emp
    JOIN employees.salaries sal ON emp.emp_no = sal.emp_no
    JOIN employees.dept_emp dpe ON dpe.emp_no = emp.emp_no
    JOIN employees.dept_manager dpm ON dpe.dept_no = dpm.dept_no
WHERE 
    (sal.emp_no , sal.to_date) IN (
    SELECT  emp_no, max(to_date)
    FROM employees.salaries
    GROUP BY emp_no) 
0 Answers
Related