在PostgreSQL中按窗口函数过滤结果

我没有使用PostgreSQL。但是，我最好的猜测是使用内联视图。

SELECt a.*FROM (    SELECt s.*, sum(volume) OVER previous_rows AS total    FROM stuff AS s    WINDOW previous_rows AS (         ORDER BY priority desc         ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW    )    ORDER BY priority DESC) AS aWHERe a.total < 1000;