mysql获取今天、近一周、近一个月的数据
mysql获取今天、近一周、近一个月的数据,直接上代码SELECT a.* ,b.*,c.* FROM(SELECT COUNT(1) AS todays FROM jenkins_data a WHERE TO_DAYS(a.commitTime) = TO_DAYS(NOW())) a//今天INNER JOIN (SELECT COUNT(1) AS we...
·
mysql获取今天、近一周、近一个月的数据,直接上代码
SELECT a.* ,b.*,c.* FROM (SELECT COUNT(1) AS todays FROM jenkins_data a WHERE TO_DAYS(a.commitTime) = TO_DAYS(NOW())) a //今天
INNER JOIN (SELECT COUNT(1) AS weeks FROM jenkins_data b WHERE b.commitTime > DATE_SUB(CURDATE(), INTERVAL 1 WEEK)) b //近一周
INNER JOIN (SELECT COUNT(1) AS months FROM jenkins_data c WHERE c.commitTime > DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) c //近一个月
更多推荐
已为社区贡献3条内容
所有评论(0)