我正在尝试找到当前行和上一行之间的差异。但是,我却收到以下错误信息:
多部分标识符"tableName"无法绑定。
不确定如何解决这个错误。
谢谢!
输出应该如下所示:
columnOfNumbers Difference
1 NULL
2 1
3 1
10 7
12 2
.... ....
代码:
USE DATABASE;
WITH CTE AS
(SELECT
ROW_NUMBER() OVER (PARTITION BY tableName ORDER BY columnOfNumbers) ROW,
columnOfNumbers
FROM tableName)
SELECT
a.columnOfNumbers
FROM
CTE a
LEFT JOIN CTE b
ON a.columnOfNumbers = b.columnOfNumbers AND a.ROW = b.ROW + 1