select to_char(add_months(sysdate,-ROWNUM+1), 'yyyy-MM') day from dual connect by 12 >= ROWNUM
最近一年的月份
最新推荐文章于 2024-08-21 18:16:36 发布
select to_char(add_months(sysdate,-ROWNUM+1), 'yyyy-MM') day from dual connect by 12 >= ROWNUM