select * from
(select h.* , row number() over(partition by h.group_id order by h.rule_code desc) rn
from t_test h
) t where t.rn <=1
select * from
(select h.* , row number() over(partition by h.group_id order by h.rule_code desc) rn
from t_test h
) t where t.rn <=1