给定一个年月 获取当月的所有日期
记录一下 给定一个年月 获取当月的所有日期
SELECT
da.das AS das
,IFNULL( sum( t1.date ), 0 ) AS number
FROM
( SELECT ( date_add( date_format(now(), '%Y-%m-%d' ), INTERVAL ( cast( help_topic_id AS signed ) - 31 ) DAY ) ) das FROM mysql.help_topic ORDER BY help_topic_id ) da
LEFT JOIN (
SELECT COUNT(t1.habit_start_date) AS date,t1.habit_start_date AS start_date,t1.habit_end_date AS end_date FROM sch_teacher_publish_habit t1
LEFT JOIN sch_class t2 ON t2.deleted = 0 AND t2.user_id = '0ea0bc482d652da8718e0e682c8faf51' AND FIND_IN_SET(t1.class_id,t2.id)
WHERE t1.deleted = 0
) t1 ON da.das BETWEEN date_format( t1.start_date, '%Y-%m-%d' ) AND date_format( t1.end_date, '%Y-%m-%d' )
WHERE
( date_format( da.das, '%Y-%m' ) = '2021-02' OR date_format( da.das, '%Y-%m' ) = '2021-02' )
GROUP BY da.das
ORDER BY da.das
上述示例展示的是 left join里面关联的是数据库中的表 该sql 返回值为
List<Map<String, Object>>
还没有评论,来说两句吧...