SQL获取月份临时表

最新推荐文章于 2024-07-19 16:12:43 发布

皮蛋的皮蛋壳

最新推荐文章于 2024-07-19 16:12:43 发布

阅读量57

点赞数

文章标签： sql mysql

本文链接：https://blog.csdn.net/weixin_44861285/article/details/129142187

版权

以获取过去12个月为例子

select date_format(date_sub(now(), interval biao.count month), '%Y-%m') as yuefen 
FROM 
(select t.c as count from (
    select 0 as c 
    union select 1 as c 
    union select 2 as c 
    union select 3 as c 
    union select 4 as c 
    union select 5 as c 
    union select 6 as c 
    union select 7 as c 
    union select 8 as c 
    union select 9 as c 
    union select 10 as c 
    union select 11 as c ) AS t
) AS biao