查询2个不关联表数据库最近的7天数据

最新推荐文章于 2022-11-24 10:31:10 发布

无与丶伦比丨

最新推荐文章于 2022-11-24 10:31:10 发布

阅读量314

点赞数

文章标签：数据库 database

本文链接：https://blog.csdn.net/weixin_42714661/article/details/99674116

版权

(
    SELECT
        COUNT(*) AS total,
        DATE_FORMAT(exam_time, '%Y-%m-%d') AS times
    FROM
        tb_sys_exam_score
WHERE
    exam_time BETWEEN '2019-08-10 00:00:00' AND '2019-08-16 00:00:00'
    GROUP BY
        DATE_FORMAT(exam_time, '%Y-%m-%d')
)
UNION
    (
        SELECT
            COUNT(*) AS total,
            DATE_FORMAT(study_time, '%Y-%m-%d') AS times
        FROM
            tb_sys_study_record
    WHERE
    study_time BETWEEN '2019-08-10 00:00:00' AND '2019-08-16 00:00:00'
        GROUP BY
            DATE_FORMAT(study_time, '%Y-%m-%d')
    )
ORDER BY
    times DESC




菜鸟，勿喷。。。