PGSQL获取过去30天，7天，昨天，今天的数据

xiaozanwain

于 2022-04-18 08:56:55 发布

阅读量5.2k

点赞数 1

文章标签： postgresql

本文链接：https://blog.csdn.net/xiaozanwain/article/details/124241248

版权

        select
        count(*) as allBookCount,
        count(*) filter(where createtime between (SELECT current_date - interval '30 day') and current_date ) as
        last30DAddBookCount ,
        count(*) filter(where createtime between (SELECT current_date - interval '7 day') and current_date) as
        last7DAddBookCount ,
        count(*) filter(where createtime between (SELECT current_date - interval '1 day') and current_date) as
        yesterdayAddBookCount ,
        count(*) filter(where createtime >=current_date ) as todayAddBookCount
        from t_e_book