我正在尝试设置偏移量(Offset)和限制数量(Limit),我已经尝试了以下方法:
SELECT
[Job_No]
, ROW_NUMBER() OVER (ORDER BY [Job_No]) AS [rownumber]
, [BaselineStart]
, [BaselineFinish]
, [ExpectedStart]
, [ExpectedFinish]
, [ScheduledStart]
, [ScheduledFinish]
, [ActualStart]
, [ActualFinish]
FROM
[Schedule]
WHERE
[rownumber] BETWEEN 10 AND 20;
但是我遇到了这个错误:
请帮忙解决。无效的列名 'rownumber'。