MYSQL8 窗口函数

select row_number() OVER (PARTITION BY carrier_id ORDER BY end_time desc ) AS row_num,carrier_id,end_time
from t_sens_task_result where  end_time is not null)
m where row_num=1

解释 从这个表中按照end_time倒序 取出最新的carrier_id
重点 ow_number() OVER (PARTITION BY carrier_id ORDER BY end_time desc ) AS row_num