select a.result,a.createTime
from (
select result, date_format(create_time, '%Y-%m-%d') as createTime,
row_number() over (partition by date_format(create_time, '%Y-%m-%d') order by create_time desc) rowNum
from data_task_result
where tag_id = '331016'
) as a
where rowNum = 1
MySQL分组的时候取里面的第一条数据
最新推荐文章于 2024-07-18 04:05:49 发布