select e.dept_no,e.emp_no,max(salary)
from dept_emp e,salaries s
where e.emp_no=s.emp_no
group by e.dept_no 吧
order by e.dept_no asc
group by后默认取每组第一个值
利用窗口函数:
select
sma.dept_no,sma.emp_no,sma.salary
from(
select
e.dept_no,e.emp_no,s.salary,
dense_rank()over(partition by e.dept_no order by s.salary
desc) as rk
from
dept_emp e,salaries s
where
e.emp_no=s.emp_no
)sma
where sma.rk=1