意思不是很懂，不知道对不对，
你可以用row_number() over(partition by xx order by xx)函数试下；
select a.id,a.xing,a.ming,a.nian,T2.age from T1 as a left outer join
(SELECT row_number() over ( order by age) as ln,aid,age FROM T2 ) T2
on a.id=T2.aid
where T2.ln=1
order by t2(时间字段) desc
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024