问Postgresql如何按时间以集合顺序求出最大值和最小值

EN

WITH cte AS (
    SELECT *, ROW_NUMBER() OVER (ORDER BY Time) rn1,
              ROW_NUMBER() OVER (PARTITION BY Area ORDER BY Time) rn2
    FROM yourTable
)

SELECT Time, Area,
       MAX(Time) OVER (PARTITION BY Area, rn1 - rn2) AS MaxTime,
       MIN(Time) OVER (PARTITION BY Area, rn1 - rn2) AS MinTime
FROM cte
ORDER BY Time;