MySQL，查询最近一个月每天的最后一条数据

测试数据

查询sql语句如下

select max(aa.rq) as MaxcreateTime ,aa.result,aa.xulie
from
(
select convert(a.rq,CHAR(10)) datetemp,a.rq,a.result,a.xulie
from test a
where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(a.rq)
GROUP BY a.rq
ORDER BY a.xulie desc
) as aa
group by aa.datetemp

输出结果集