17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT order1, date1, date2, name1
FROM (SELECT a.order1,
a.date1,
b.date1 date2,
b.name1,
ROW_NUMBER() OVER(PARTITION BY a.order1 ORDER BY b.date1 DESC) rn
from a, b
where a.order1 = b.order1
and a.date1 > b.date1)
WHERE rn = 1;
select t2.order,t2.date,t2.max_dt,t1.name from b t1,
(select a.order,a.date,(select max(b.date) from b where a.order=a.order and a.date>b.date)max_dt from a)t2
where t1.order=t2.order
and t1.date=t2.date