根据 driver_id 分组,查询 car_storage_time 最大的那条数据。
SELECT
bcs.car_id,
bcs.driver_id,
bcs.shift_id,
bcs.route_id,
bcs.car_storage_time,
FROM
bus_car_storage bcs
INNER JOIN ( SELECT driver_id, max( car_storage_time ) lastUpdate FROM bus_car_storage GROUP BY driver_id ) bcs1 ON bcs.driver_id = bcs1.driver_id
AND bcs1.lastUpdate = bcs.car_storage_time