select distinct a.REPORT_TIME,a.FRA05,b.area_name,from TB_JP_JA2001_DATA a,t_area b where a.FRA05 = b.area_code and FRA05 like ('43%') and A12='1' or DWBS='10' group by a.REPORT_TIME,a.FRA05,b.area_name不好意思,我砍错了一点~~~基本上应该不是sql语句的问题
select a.REPORT_TIME,a.FRA05,b.area_name from TB_JP_JA2001_DATA a,t_area b where a.FRA05 = b.area_code and FRA05 like '43%' and A12='1' or DWBS='10' group by a.REPORT_TIME,a.FRA05,b.area_name在sql*plus里面试一下,看有没有问题
TB_JP_JA2001_DATA a,t_area b where a.FRA05 = b.area_code and FRA05 like ('43%') and A12='1' or DWBS='10'
group by a.REPORT_TIME,a.FRA05,b.area_name不好意思,我砍错了一点~~~基本上应该不是sql语句的问题
from TB_JP_JA2001_DATA a,t_area b
where a.FRA05 = b.area_code and FRA05 like '43%' and A12='1' or DWBS='10'
group by a.REPORT_TIME,a.FRA05,b.area_name在sql*plus里面试一下,看有没有问题
我这个是出奇的慢,原本零点几秒可以出结果的,现在要到n分钟后都没有动静,有时候会报
temp出错,一看,20G的temp表都满了,而这条sql语句不可能造成这种结果,痛苦ing