它是:
SELECT
[Date],
Hour,
Node,
(Value +
(Select Value
From tblInput As T
Where
T.Node = tblInput.Node And
T.Date = tblInput.Date And
T.Hour = tblInput.Hour - 1)) / 2
FROM
tblInput
WHERE
Hour In (2,3,4)