sql - 从当前月份获取前 12 个月的名称/ID

Question

任何人都可以帮助我从当前日期(月份)获取最近 12 个月的名称。我想在 sql server 中进行此查询。

Answer 1

您可以为您的解决方案使用通用表表达式:

;WITH DateRange AS(
    SELECT GETDATE() Months
    UNION ALL
    SELECT DATEADD(mm, -1, Months)
    FROM   DateRange

    WHERE Months > DATEADD(mm, -11, GETDATE())
)

SELECT DateName(m, Months) AS Months, Month(Months) AS ID FROM DateRange

按顺序显示前几个月:

    Months                         ID
------------------------------ -----------
January                        1
December                       12
November                       11
October                        10
September                      9
August                         8
July                           7
June                           6
May                            5
April                          4
March                          3
February                       2