表: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;
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 )
select t.*, rank() over(partition by dept order by age desc) rk from t
) where rk=1;