--根据 x 分组后、根据 y 排序
SELECT
*
FROM
(
select ROW_NUMBER () over (PARTITION BY x ORDER BY y DESC) AS roNum ,
mmsdplanclausekind.*
FROM
mmsdplanclausekind
) t1 where roNum = 1
SELECT
*
FROM
(
select ROW_NUMBER () over (PARTITION BY x ORDER BY y DESC) AS roNum ,
mmsdplanclausekind.*
FROM
mmsdplanclausekind
) t1 where roNum = 1