TABLE-S6
CODE
T1
T2
T3
TABLE-S9
CODE CARCODE
T1 AA
T1 BB
T2 CC
TABLE-R2
CODE CARCODE DATE TAG
T1 AA 2007-11-10 10
T1 AA 2007-11-12 11
T1 AA 2007-11-11 20
需要结果
CODE CARCCODE DATE TAG
T1 AA 2007-11-12 11
T1 BB
T2 CC
T3
CODE
T1
T2
T3
TABLE-S9
CODE CARCODE
T1 AA
T1 BB
T2 CC
TABLE-R2
CODE CARCODE DATE TAG
T1 AA 2007-11-10 10
T1 AA 2007-11-12 11
T1 AA 2007-11-11 20
需要结果
CODE CARCCODE DATE TAG
T1 AA 2007-11-12 11
T1 BB
T2 CC
T3
解决方案 »
- 关于创建ORACLE 存储过程的问题
- oracle erp工具有哪些
- ------------------------------------------------刪除相同紀錄----------------------------------------------------
- 求cnoug邀请码
- 请问“ORA-04068: 程序包 的现有状态已被丢弃”是怎么回事,怎么解决?
- 请教一条sql语句
- 请教:我正在学Oracle的命令,但是不可能全记住啊,Oralce软件上有这些命令帮助吗?
- 怎么我恢复数据库时,所有触发器没有了?
- 如何限定一个表里面的最大纪录数?
- 如何使用oracle8i中的同义词
- 求一个Sql server转成oracle的写法
- 一条SQL语句解决复杂多记录插入的问题...
select s6.code,s9.carcode,aa.date,aa.tag from s6
left join s9
on s6.code=s9.code
left join
(select * from r2 a,
(select code,carcode, max(date) from r2 group by code,carcode) b
where a.code=b.code and a.carcode=b.carcode and a.date=b.date) aa //取得最大date记录后的表
on s9.code=aa.code and s9.carcode=aa.carcode
select * from
(select s6.code,s9.carcode from ms06 s6 ,ms09 s9 where s6.code=s9.code(+) )M ,
(select code,carcode,max(ddate) from tr02 r2 group by code,carcode) T
where m.code=t.code(+) and m.carcode=t.carcode(+)不知道我这个方法效率怎么样?或者有效率高的,请高人指点
From s6 a Left Join s9 b On a.code=b.code
Left Join (Select * From r3 a Where a.date1 In(Select Max(date) From r3 Group By carcode)) c
On b.carcode=c.carcode
Order By a.code