mysql查询某一字段最新一条数据

2020-06-02 本文已影响0人浅浅星空

select * from 
(
select SITE_CAR_TYPE_ID,UPDATED_STAMP from car_price_change_workcard order by UPDATED_STAMP desc
) temp
GROUP BY SITE_CAR_TYPE_ID