遗憾的
LAG是，SQL Server 2012之前的版本不可用。您必须使用
ROW_NUMBER自连接来代替：
;With Quote as ( SELECt SID, SHEET,Code, [Date], Data, ROW_NUMBER() OVER (ORDER BY [Date]) AS rn FROM RMQ_DATA WHERe [SHEET] IN (0)), Quote_LAG AS ( SELECt q1.SID, q1.SHEET, q1.Code, q1.[Date], q1.Data, q2.Data AS LastMonthData FROM Quote AS q1 LEFT JOIN Quote AS q2 ON q1.rn = q2.rn + 1)... rest of the query here
