SQL 中求max()的问题

2025-02-26 05:09:51

推荐回答（3个）

回答1：

select 编号,姓名,级别 from [user] where 编号 in (
select max(编号) from [user] a inner join
(select 部门, max(级别) as 级别 from [user] group by 部门) b
on a.部门=b.部门 and a.级别=b.级别
group by b.部门, b.级别
)

回答2：

SELECT
*
FROM
user
WHERE
NOT EXISTS(
SELECT 1 FROM user subUser
WHERE user.部门 = subUser.部门
ANE user.级别 < subUser.级别
)

回答3：

select 编号,姓名, b.部门, top级别
from user a inner join
(select 部门, max(级别) as top级别 from user group by 部门) as b
on a.部门=b.部门
and a.级别=b.top级别
order by 编号,姓名