（高分求解）数据库条记录中，查询出来总共的 Q值，以及，最大的P值，最大P值对应发生的时间。

[滴答滴答昵称]

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

[滴答滴答昵称]

有人没？？？快来人啊

[bw555]

MAX(YS.OCCUR_TIME) OVER() AS MAXTIME 改为 MAX(YS.OCCUR_TIME) keep(dense_rank last order by YS.P) AS MAXTIME

[滴答滴答昵称]

我的数据库是 DB2。 报错了

[IBM][CLI Driver][DB2/NT] SQL0104N  在 "X(YS.OCCUR_TIME) KEY" 后面找到异常标记 "("。预期标记可能包括："FROM"。  SQLSTATE=42601

[bw555]

这是oracle区，给你写的是oracle的写法，帮你转到db2的板块去吧

[滴答滴答昵称]

感谢，感谢，感谢，感谢

[littlebrain4solving]

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

[滴答滴答昵称]

[CLI Driver][DB2/NT] SQL0119N  在 SELECT 子句、HAVING 子句 或 ORDER BY 子句中指定的以 "OCCUR_TIME" 开始的表达式未在 GROUP BY 子句中指定，或者它在 SELECT 子句、HAVING 子句或 ORDER BY 子句中，具有列函数，但未指定 GROUP BY 子句。  SQ

这是什么情况啊？？大神

[滴答滴答昵称]

SELECT
    YS.ACLN_ID,
    YS.ACLN_NAME,
    SUM(abs(YS.P)) AS SUMP,
    YS1.P AS MAXP,
    YS1.OCCUR_TIME AS MAXTIME,
    YS2.P AS MINP,
    YS2.OCCUR_TIME AS MINTIME
FROM GRID.LINE_LOSS_DAY YS,
    (SELECT A.P, A.OCCUR_TIME FROM GRID.LINE_LOSS_DAY A ORDER BY A.P DESC FETCH FIRST 1 ROWS ONLY) YS1,
    (SELECT B.P, B.OCCUR_TIME FROM GRID.LINE_LOSS_DAY B ORDER BY B.P ASC FETCH FIRST 1 ROWS ONLY) YS2
WHERE YS.ACLN_ID = 240000075
AND YS.CITY_ID= 5
GROUP BY
    YS.ACLN_ID,
    YS.ACLN_NAME,
    YS1.P,
    YS1.OCCUR_TIME,
    YS2.P,
    YS2.OCCUR_TIME;

[滴答滴答昵称]

SELECT
    YS.ACLN_ID,
    YS.ACLN_NAME,
    SUM(YS.Q)                 AS SUMQ,
    YS.P         AS    MAXP,
    YS.OCCUR_TIME AS MAXTIME,
	YS.Q AS MINQ,
	YS.OCCUR_TIME AS MINTIME
FROM
    GRID.LINE_LOSS_DAY YS,
    (SELECT A.P,A.OCCUR_TIME,A.Q,A.OCCUR_TIME FROM GRID.LINE_LOSS_DAY A  ORDER BY A.P DESC FETCH FIRST 1 ROWS ONLY) YS1
WHERE
     YS.ACLN_ID = 240000075
GROUP BY
    YS.ACLN_ID,
    YS.ACLN_NAME,
    YS.P,
	YS.Q,
    YS.OCCUR_TIME

大神，这个脚本对不对。