2020-10-21

it2024-01-23  59

萌新提问 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”

最新回复(0)