#按年统计
SELECT SUM(browseNum) AS browseNum, COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY DATE_FORMAT(DATE, '%Y');
#按月统计
SELECT SUM(browseNum) AS browseNum,SUM(downloadNum) AS downloadNum,SUM(telBrowseNum) AS telBrowseNum,DATE_FORMAT(DATE, '%Y-%m'),
SUM(telDownloadNum) AS telDownloadNum,
COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY DATE_FORMAT(DATE, '%Y-%m');
#按季度统计
SELECT SUM(browseNum) AS browseNum,SUM(downloadNum) AS downloadNum,SUM(telBrowseNum) AS telBrowseNum,
CONCAT(DATE_FORMAT(DATE, '%Y'),FLOOR((DATE_FORMAT(DATE, '%m')+2)/3)) AS jidu,
SUM(telDownloadNum) AS telDownloadNum,
COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY CONCAT(DATE_FORMAT(DATE, '%Y'),FLOOR((DATE_FORMAT(DATE, '%m')+2)/3));
mysql 按年度、季度、月度
最新推荐文章于 2024-07-30 04:02:29 发布