2020-10-21

萌新提问 maxtime如何优化max的参数

“select “MAXTIME1”,
“DELAY1”
,“MAXTIME2”
,“DELAY2”
,“MAXTIME3”
,“DELAY3”
FROM
(select max(a.stat_time) as “MAXTIME1”,round（(sysdate-max(a.stat_time ))6024,2） as “DELAY1” from IPMSDW.O_RE_ST_PGW_PGWFUNCTION_ER_15M a) t1,
(select max(b.stat_time) as “MAXTIME2”,round（(sysdate-max(b.stat_time ))2460,2）as “DELAY2” from IPMSDW.O_RE_ST_PGW_EPRPDYNS5S8_ER_15M b) t2,
(select max(c.stat_time) as “MAXTIME3”,round（trunc(sysdate)-trunc(max(c.stat_time )),2）as “DELAY3” from IPMSDW.O_RE_BA_PGW_PGWFUNCTION_ER_D c) t3”