sql server中上一年、同月、日期、小时的滞后/领先

SELECT 
    [Column],
    LAG([Column], 1) OVER (ORDER BY [Date]) AS LaggedValue,
    LEAD([Column], 1) OVER (ORDER BY [Date]) AS LeadedValue
FROM [Table]
WHERE [Date] >= DATEADD(YEAR, -1, GETDATE())

SELECT 
    [Column],
    LAG([Column], 1) OVER (PARTITION BY MONTH([Date]) ORDER BY [Date]) AS LaggedValue,
    LEAD([Column], 1) OVER (PARTITION BY MONTH([Date]) ORDER BY [Date]) AS LeadedValue
FROM [Table]
WHERE MONTH([Date]) = MONTH(GETDATE())

SELECT 
    [Column],
    LAG([Column], 1) OVER (PARTITION BY CAST([Date] AS DATE) ORDER BY [Date]) AS LaggedValue,
    LEAD([Column], 1) OVER (PARTITION BY CAST([Date] AS DATE) ORDER BY [Date]) AS LeadedValue
FROM [Table]
WHERE CAST([Date] AS DATE) = CAST(GETDATE() AS DATE)

SELECT 
    [Column],
    LAG([Column], 1) OVER (PARTITION BY DATEPART(HOUR, [Date]) ORDER BY [Date]) AS LaggedValue,
    LEAD([Column], 1) OVER (PARTITION BY DATEPART(HOUR, [Date]) ORDER BY [Date]) AS LeadedValue
FROM [Table]
WHERE DATEPART(HOUR, [Date]) = DATEPART(HOUR, GETDATE())