本帖最后由 Nian_jun 于 2012-12-5 10:08 编辑
结果集 反了吧
aaaaaa
20121110 p
bbbbbb
20121115 p
不用分析函数
witht as(
select 'aaaaaa' fact_odr_no,20121110 send_date,'p' result from dual
union all
select 'aaaaaa',20121103,'f' from dual
union all
select 'bbbbbb',20121115,'p' from dual
union all
select 'bbbbbb',20121103,'F' from dual
)
select * fromt where (fact_odr_no, send_date)in (select fact_odr_no,max(send_date) from t group by fact_odr_no)
复制代码
|