获取分组最新数据

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