按MeterID分组,按CurrentReadDate时间倒序,取第一行

 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
 

posted @ 2014-10-15 22:42  王者(姓王)  阅读(252)  评论(0编辑  收藏  举报