17,377
社区成员
发帖
与我相关
我的任务
分享
select b.bankid,b.ccy,b.point,b.date,b.time,
a.bankid,a.ccy,a.point,max(a.date||a.time)
from a,b
where a.bankid = b.bankid
and a.ccy = b.ccy
and a.point = b.point
and b.date||b.time >= a.date||a.time
group by b.bankid,b.ccy,b.point,b.date,b.time,
a.bankid,a.ccy,a.point
--好吧,既然你执意要求那就给你写一个,
--不过事先声明:从你给的信息和数据看,这个sql肯定能办到,但是不一定适用你的真实情况,因为你的需求太含糊
select b.bankid,b.ccy,b.point,b.date,b.time,
a.bankid,a.ccy,a.point,a.date,a.time
from a,b
where a.bankid = b.bankid
and a.ccy = b.ccy
and a.point = b.point
and b.date||b.time >= a.date||a.time;