17,089
社区成员
发帖
与我相关
我的任务
分享
select id, trunc(createtime),sum(run_time)
from (
select id, endtime-createtime run_time from t1
union all
select id, createtime-endtime run_time from t2
)group by id,trunc(createtime)
select id, sum(run_time)
from (
select id, endtime-createtime run_time from t1
union all
select id, createtime-endtime run_time from t2
)group by id
select tt1.id, run_time - nvl(stop_time, 0)
from (select id, sum(endtime - createtime) run_time from t1 group by id) tt1,
(select id, sum(endtime - createtime) stop_time from t2 group by id) tt2
where tt1.id = tt2.id(+)