select a.name,a.sex,a.city,b.graduatedate,b.graduateschool from t1 a,t2 b where a.name = b.name and (b.name,b.graduatedate) in (select name,max(graduatedate) from t2);
select a.name,a.sex,a.city,b.graduatedate,b.graduateschool from t1 a, (select name,graduatedate,graduateschool,rank() over(partition by name order by graduatedate desc) listorder from t2) b where a.name=b.name and b.listorder=1;
select a.name,a.sex,a.city,b.graduatedate,b.graduateschool from t1 a,t2 b where a.name = b.name and (b.name,b.graduatedate) in (select name,max(graduatedate) from t2);
from t1 a,
(select name,graduatedate,graduateschool,rank() over(partition by name order by graduatedate desc) listorder from t2) b
where a.name=b.name and b.listorder=1;