我补充一下,在每一个table中的ida2a2都是唯一的标示
解决方案 »
- 菜鸟弱弱的问下Oracle与SqlServer最大的区别是什么
- oracle 中 一个插入的问题
- oracle中job的用法
- 关于oracle group by的问题
- oracle中的.dbf文件 碎片整理问题
- 千呼万唤始出来的Oracle 10g Release 2目前已经提供下载,为什么会这样??
- 关于oracle数据库表的纪录删除
- 装了三个多小时还没装上,咋办??
- 如何使不同数据库转换自动化(oracle 高级问题),在线等待!
- PL/SQL Developer无法进行调试,请帮助解决.
- 一个关于日期(星期)转换的问题~谢谢
- 吐血推荐,为了oracle的初学者们不在像我当难年那样......
from (select a.* from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
order by a.VALUEA2B2VERSIONINFO desc) aa
where aa.rownum<2
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
and a.VALUEA2B2VERSIONINFO= (
select max(a.VALUEA2B2VERSIONINFO)
from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)')
但是呢,要是我的条件是c.projectid like 'M%'的话,好像就不好用了!!
-----------------------------------------------------------------------
呵呵,我觉得只要你的这句
select a.* from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
筛选正确,应该还是没有问题地,因为我的这句只是根据你的结果作了一次排序操作,
然后取一条记录。
select a.ida3b10 id,max(a.VALUEA2B2VERSIONINFO) max_v
from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
group a.ida3b10) e
where d.VALUEA2B2VERSIONINFO=e.max_v
and a.ida3b10=e.id
and rownum=1
(select a.*,row_number() over(order by VALUEA2B2VERSIONINFO desc) rm
from au3.dqabaseline a ,au3.dqamilestone b,au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)')
where rm=1
where ida2a2 in (
select max(a.ida2a2) ida2a2 from au3.dqabaseline a ,au3.dqamilestone b,au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid like 'M190EN02%'
group by a.ida3masterreference)
这个是我写的,感觉比较烂,请大家指正!
select a.ida3b10 id,max(a.VALUEA2B2VERSIONINFO) max_v
from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
group a.ida3b10) e
where d.VALUEA2B2VERSIONINFO=e.max_v
and d.ida3b10=e.id
and rownum=1
上次有點錯誤,不好意思,rownum=1是為了防止多行返回,你可以先不寫的!
thank you all the same
这个东西是什么作用?
from (select a.* from au3.dqabaseline a ,
au3.dqamilestone b,
au3.dqabaselinemaster c
where a.ida3b10=b.ida2a2
and a.ida3masterreference=c.ida2a2
and c.projectid='M190EN02 V.2 (L8-ODF)'
order by a.VALUEA2B2VERSIONINFO desc) aa
where aa.rownum<2