(高分求解)数据库条记录中,查询出来合共的 Q值,以及,最大的P值,最大P值对应发生的时间
(高分求解)数据库条记录中,查询出来总共的 Q值,以及,最大的P值,最大P值对应发生的时间。
------解决思路----------------------
MAX(YS.OCCUR_TIME) OVER() AS MAXTIME
改为
MAX(YS.OCCUR_TIME) keep(dense_rank last order by YS.P) AS MAXTIME
------解决思路----------------------
SELECT
YS.ACLN_ID,
YS.ACLN_NAME,
SUM(YS.Q) AS SUMQ,
MAX(YS.P) OVER() MAXP,
MAX(YS.OCCUR_TIME) OVER() AS MAXTIME
FROM
GRID.LINE_LOSS_DAY YS
WHERE
YS.CITY_ID = 3
AND YS.ACLN_ID = 240000075
GROUP BY
YS.ACLN_ID,
YS.ACLN_NAME,
YS.P,
YS.OCCUR_TIME
------解决思路----------------------
MAX(YS.OCCUR_TIME) OVER() AS MAXTIME
改为
MAX(YS.OCCUR_TIME) keep(dense_rank last order by YS.P) AS MAXTIME
------解决思路----------------------
SELECT
YS.ACLN_ID,
YS.ACLN_NAME,
SUM(YS.Q) AS SUMQ,
YS1.P MAXP,
YS1.OCCUR_TIME MAXTIME
FROM
GRID.LINE_LOSS_DAY YS,
(SELECT P,OCCUR_TIME FROM GRID.LINE_LOSS_DAY ORDER BY P DESC FETCH FIRST 1 ROWS ONLY) YS1
WHERE
YS.CITY_ID = 3
AND YS.ACLN_ID = 240000075
GROUP BY
YS.ACLN_ID,
YS.ACLN_NAME,
YS.P,
YS.OCCUR_TIME