34,576
社区成员
发帖
与我相关
我的任务
分享
select max(sal) from (select sum(sal) sal from emp group by deptno)a
SELECT deptno, max(SAL) sal
FROM
(
Select deptno,sum(sal) SAL from emp group by deptno
)P
GROUP BY deptno
select max(Freight)
from
(
select EmployeeID,sum(Freight) Freight from dbo.Orders group by EmployeeID
)p
SELECT deptno, max(SAL) sal
FROM
(
Select deptno,sum(sal) SAL from emp group by deptno
)P
GROUP BY deptno