原数据
筛选后数据
主要方法:max,group by,inner join
select a.* from (
select fname,fnumber,a.date1,mnumber,mname,price
from price_info a left join price_infoentry b on a.FlowID=b.FlowID where fnumber='S000259') a inner join (
select fnumber,mnumber,max(a.date1) as ctime from price_info a left join price_infoentry b on a.FlowID=b.FlowID where fnumber='S000259' group by fnumber,mnumber) b
on a.fnumber=b.fnumber and a.mnumber=b.mnumber and a.date1=b.ctime