您可以使用以下内容：
select t1.id, t2.mxdate, t1.valuefrom yourtable t1inner join( select max(date) mxdate, id from yourtable group by id) t2 on t1.id = t2.id and t1.date = t2.mxdate
观看演示
您可以使用以下内容：
select t1.id, t2.mxdate, t1.valuefrom yourtable t1inner join( select max(date) mxdate, id from yourtable group by id) t2 on t1.id = t2.id and t1.date = t2.mxdate
观看演示
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
