求助：oracle中group by分组语句解惑！谢谢
表:T
name age dept
aa 24 1
bb 28 3
cc 30 2
dd 34 1
ee 35 1
ff 45 2
hh 37 3

欲求的检索信息结果

dept name age
1 ee 35
2 ff 45
3 hh 37

以下语句要做如何修改满足该要求？谢谢

select dept,name,max(age)
from T
group by dept,name;



[解决办法]
用自关联子查询就行了
select * from t a where
age = (select max(age) from t b a.dept = b.dept )
[解决办法]

SQL code

select dept, name, age from(  select t.*, rank() over(partition by dept order by age desc) rk from t) where rk=1;