34道mysql作业题

分类: 文章 • 2024-12-07 12:07:34

第一题

select e.ename,t.*
from
(select e.deptno,max(e.sal) as maxsal
from emp e
group by deptno) t
join emp e
on t.maxsal = e.sal and t.deptno = e.deptno;

34道mysql作业题