SELECT
mti.MatnrID,mti.LifnrID,mti.PriceDatBeg,mti.PriceDatEnd
FROM
(SELECT MatnrID,MAX(AddDate) AddDate FROM MatnrInfo GROUP BY MatnrID) a
LEFT JOIN MatnrInfo mti ON mti.MatnrID = a.MatnrID AND mti.AddDate = a.AddDate
注:表MatnrInfo需要建索引,不然会慢的很