sql按月统计数据和按月统计累计数量
sql按月统计数据和按月统计累计数量1.简单的,按月统计数量SELECT CREATE_DATE, DATE_FORMAT(CREATE_DATE, '%Y-%m') AS month, COUNT(*) AS sumFROM pt_userGROUP BY month;2.按月累加统计数据SELECT a.month, SUM(b.total) AS totalFROM ( SELECT DATE_FORMAT(CREATE_DATE, '%Y-%m') AS month, SUM







