SELECT t.dept_no, t.emp_no, t.salary FROM (SELECT row_number() over(partition by d.dept_no order by s.salary desc) as row_num, d.dept_no,d.emp_no,s.salary FROM dept_emp d INNER JOIN salaries s ON d.emp_no = s.emp_no) as t GROUP BY t.dept_no