sql 获取连续年份

1

    SELECT [year] AS [value],[year] AS label FROM (
    SELECT FORMAT(DATEADD(YEAR,-number,GETDATE()),'yyyy') AS [year] FROM master.dbo.spt_values WHERE type='p' and number<10) AS t

 

posted @ 2021-04-14 13:12  waityu  阅读(442)  评论(0)  编辑  收藏  举报