我想统计每月总人数 要加上之前的人数
SELECT
DATE_FORMAT(createtime, '%Y%m') MONTH,
count(id) count
FROM
sysuser
WHERE
STATUS = '1'
AND ! ISNULL(createtime)
GROUP BY
MONTH
![图片说明](https://img-ask.csdn.net/upload/201704/14/1492136657_294955.png)