SELECT
TO_CHAR( ds.CREAT_TIME, ‘YYYY-MM’ ),
SUM(ABILITY_NAME)
FROM
DIM_ABILITY ds
where add_months(sysdate,-3)<=CREAT_TIME
GROUP BY
TO_CHAR( ds.CREAT_TIME, ‘YYYY-MM’ )
ORDER BY
TO_CHAR( ds.CREAT_TIME, ‘YYYY-MM’ )
统计近五个月某个字段的总数
最新推荐文章于 2024-08-02 22:16:19 发布