sql按日期分组

最新推荐文章于 2024-06-07 19:48:01 发布

花长好，月长圆，人长寿

最新推荐文章于 2024-06-07 19:48:01 发布

阅读量2.6k

点赞数 1

分类专栏：数据库与SQL

本文链接：https://blog.youkuaiyun.com/qq_37977218/article/details/103972444

版权

数据库与SQL 专栏收录该内容

15 篇文章

订阅专栏

<select id="selectDayStatistics" resultType="java.util.Map">
    SELECT COUNT(1) AS num,DATE_FORMAT(create_time, '%Y-%m-%d') AS time FROM t_feedback t
    WHERE t.company_id=#{companyId} AND t.`del_flag` = 0 AND create_time LIKE CONCAT(#{time},'%')
    GROUP BY DATE_FORMAT(create_time, '%Y-%m-%d')
</select>
<select id="selectMonthStatistics" resultType="java.util.Map">
    SELECT COUNT(1) AS num,DATE_FORMAT(create_time, '%Y-%m') AS time FROM t_feedback t
    WHERE t.company_id=#{companyId} AND t.`del_flag` = 0 AND create_time LIKE CONCAT(#{time}, '%')
    GROUP BY DATE_FORMAT(create_time, '%Y-%m')
</select>
<select id="selectYearStatistics" resultType="java.util.Map">
    SELECT COUNT(1) AS num,DATE_FORMAT(create_time, '%Y') AS time FROM t_feedback t
    WHERE t.company_id=#{companyId} AND t.`del_flag` = 0 AND create_time > (#{time}-1)
    GROUP BY DATE_FORMAT(create_time, '%Y')
</select>