需要根据左图中各车型出现的最新一个日期进行排名,如A02对应的2020/5/5是最新的检测日期,则对应的车型A02排名第1,请问该SQL语句如何写?谢谢
select * from 表A as a inner join(select 车型,max(检测日期) as 检测日期 From 表A Group by 车型
) as bon a.车型=b.车型 and a.检测日期=b.检测日期
order by 检测日期 desc
order by 时间 desc
order by 检测时间 desc
SELECT * FROM (SELECT 车型, MAX(检测日期) 检测日期 FROM TABLE GROUP BY 车型) A ORDER BY A.检测日期 DESC