你可以使用 self-join 或子查询来实现这个功能。
例如,如果你想查询每一行 count 值与前一行的比较结果,你可以这样写:
WITH cte AS (
SELECT
column1,
column2,
count(column3) AS count_value,
row_number() OVER (ORDER BY column1) AS row_num
FROM
your_table
GROUP BY
column1, column2
)
SELEC