select call_date, MIN_A, MIN_B, MIN_C, MIN_D
from (
(select call_date, min MIN_A
from table1
where carrier = 'A') A,
(select call_date, min MIN_B
from table1
where carrier = 'B') B,
(select call_date, min MIN_C
from table1
where carrier = 'C') C,
(select call_date, min MIN_D
from table1
where carrier = 'D') D
where a.call_date = b.call_date and a.call_date = c.call_date and a.call_date = d.call_date
from (
(select call_date, min MIN_A
from table1
where carrier = 'A') A,
(select call_date, min MIN_B
from table1
where carrier = 'B') B,
(select call_date, min MIN_C
from table1
where carrier = 'C') C,
(select call_date, min MIN_D
from table1
where carrier = 'D') D
where a.call_date = b.call_date and a.call_date = c.call_date and a.call_date = d.call_date
解决方案 »
- 导出数据时提示Enterprise Manager 10i Console
- oracle 表空间的状态属性 online和read write 有什么区别?
- 供应商性能问题-罗
- oracle存储过程中用动态sql实现用户表名的改变(请oracle的pl/sql高手看看)
- 一个简单的关于SELECT语句的问题,急!!!
- 急啊,各位帮帮忙!100分相送
- 高分低难!大侠帮忙!没有办法就算了!!!
- 为什么我不能访问用sqlserver的dts工具导过来的数据?
- oracle9i備份後如何還原?
- Oracle表空间如何优化
- Oracle数据库中图像的存储与操作的问题
- 一个简单的不带参数的过程,警告:编译错误
楼主可以吗?
sum(decode(carrier,'A',min,0)) min_a,
sum(decode(carrier,'B',min,0)) min_b,
sum(decode(carrier,'C',min,0)) min_c,
sum(decode(carrier,'D',min,0)) min_d
FROM
(
SELECT carrier,call_date,sum(min) min
from
(
select carrier,call_date,min from table1
union
select carrier,call_date,min from table2
) t1
group by call_date,CARRIER) t2
group by call_date
sum(decode(carrier,'A',min,0)) min_a,
sum(decode(carrier,'B',min,0)) min_b,
sum(decode(carrier,'C',min,0)) min_c,
sum(decode(carrier,'D',min,0)) min_d
FROM
(
select carrier,call_date,min from table1
union
select carrier,call_date,min from table2
)
group by call_date
from table1 A,table1 B, table2 C,table2 D
where A.call_date=B.Call_date
and B.call_date=C.Call_date
and C.call_date=D.Call_date
and A.Carrier='A'
and B.Carrier='B'
and C.Carrier='C'
and D.Carrier='D'