select * from ( select Row_number() over( PARTITION BY MeterID order by a.CurrentReadDate desc) Idx,MeterID,a.CurrentReadDate,a.CurrentReadDegree from Wygl_Charge_HouseMeterDegrees a ) b where b.Idx=1