select a.linename,b.kedonglv,b.itime,b.zhixinglv from (select linename,max(id) ids from CHUHE_KEDONGLVRECORD group by linename) a inner join CHUHE_KEDONGLVRECORD b on a.ids=b.id
查找每个线号最新记录
最新推荐文章于 2023-11-06 23:15:00 发布
select a.linename,b.kedonglv,b.itime,b.zhixinglv from (select linename,max(id) ids from CHUHE_KEDONGLVRECORD group by linename) a inner join CHUHE_KEDONGLVRECORD b on a.ids=b.id