sql - GBQ 窗函数 AND 算术运算

Question

有谁知道是否可以对使用 GBQ 窗口函数得出的结果进行任何算术运算？

例如，我可以使用如下伪代码将 row_number 增加 100(某个数字):

SELECT 100 + ROW_NUMBER() OVER (PARTITION BY X ORDER BY x_id DESC) increased_row_num
FROM Table1
...

Answer 1

您将需要为此使用子查询

SELECT 100 + row_num AS increased_row_num FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY X ORDER BY x_id DESC) AS row_num
FROM Table1
)