select ta.fdate,
ta.fzqdm,
ta.fszsh,
ta.fhqssj,
ta.fhqpjj,
ta.flybz,
ta.fjjdm
from (select *
from A2011
where fdate <= to_date('2011-08-16', 'yyyy-mm-dd')) ta
join (select max(fdate) as fdate, fzqdm, fszsh
from A2011
where fsh = 2
and fdate <= to_date('2011-08-16', 'yyyy-mm-dd')
group by fzqdm, fszsh) tb on ta.fdate = tb.fdate
and ta.fzqdm = tb.fzqdm
and ta.fszsh = tb.fszsh
where fsh = 2该sql语句在9I版本中执行超慢!10G没问题! 请问是什么原因!? 有什么办法解决吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货