一栋楼有很多水表,每天都会不定时上传数据,我想获取表半年内每个月每个水表最后一次上传的数据
SELECT
DATE_FORMAT(CREAT_DATE, '%Y-%m'),
SUM(PROPERTY_VALUE)
FROM
(SELECT
*
FROM
s_water
WHERE CREAT_DATE BETWEEN DATE_SUB(NOW(), INTERVAL 5 MONTH)
AND NOW()) AS a
GROUP BY DATE_FORMAT(CREAT_DATE, '%Y-%m')
这样算的话会把每个月的上报数据都算出总和,我想过滤掉不是最后一条的数据