select a.polno ,a.prem ,a.amnt ,a.signdate ,a.appno,b.address ,b.zipcode ,b.phone ,b.makedate
from pol_main a
left join
(select *
from (select t.*,row_number() over(partition by appno order by 录入makedate 期 desc ) rn from lcaddress t)
where rn=1
)b
on a.appno=b.appno
from pol_main a
left join
(select *
from (select t.*,row_number() over(partition by appno order by 录入makedate 期 desc ) rn from lcaddress t)
where rn=1
)b
on a.appno=b.appno
解决方案 »
- sql INSERT INTOYU语句错误,请各位大神看看帮帮忙!
- dell 2950 8CPU 4G内存,oracle sga设置请教?
- 请高手赐教:关于oracle中 "On Delete Cascade(连带删除)"的问题?
- 在批处理命中如何调用oralce的存储过程
- Oracle10g使用DBCA创建数据库模板报“ORA-07445”
- 如何取得指定日期的下一个月?
- 登陆Oracle Enterprise Management Servers时抛出异常!大家帮忙看看!
- 异构数据库互联
- ORACLE 动态拼接语句问题
- session阻塞的问题
- sql求助
- sqlldr装在效率问题,请高手给个方案,有具体环境描述
a.Prem,
a.Amnt,
a.Signdate,
a.Appno,
b.Address,
b.Zipcode,
b.Phone
FROM Pol_Main a,
(SELECT Appno,
Address,
Zipcode,
Phone
FROM (SELECT Appno,
Address,
Zipcode,
Phone,
Makedate,
Row_Number() Over(PARTITION BY Appno ORDER BY Makedate DESC) AS Rn
FROM Lcaddress)
WHERE Rn = 1) b
WHERE a.Appno = b.Appno;