SQL อยาก select ค่าที่ให้แสดงค่าที่อัพเดตล่าสุดอย่างเดียว

select 
m_car_id,
(select car_empty_weight from _car_emptyweight where car_id = m_car_id
and date_modified =  m_date_modified) as car_empty_weight,
m_date_modified
 from (
select car_id as m_car_id,
max(date_modified) as m_date_modified 
from _car_emptyweight
group by car_id
) as t;

select o.* 
from tbname o, (select id, max(dte) mxd from tbname group by id) g
where o.id = g.id and o.dte=g.mxd

SELECT `_car_emptyweight`.*
FROM `_car_emptyweight`, 
(SELECT car_id, MAX(date_modified) AS mxd FROM `_car_emptyweight`
GROUP BY car_id)  as g  
WHERE `_car_emptyweight`.car_id = `g`.car_id and `_car_emptyweight`.date_modified = `g`.mxd
ORDER BY `_car_emptyweight`.car_id