获取分组最新数据

SELECT     b.* FROM     (         SELECT             a.*,             row_number() over (partition BY SegmentName ORDER BY [YEAR] DESC,[MONTH] DESC) rn         FROM             T_Stat_WaterQualityStatistics a) b WHERE     rn=1