SELECT TAB_A.* FROM (
SELECT a.*, ROW_NUMBER() OVER( PARTITION BY a.分组字段 ORDER BY a.排序字段 DESC ) ROWNO
FROM 表1 a
) TAB_A
WHERE ROWNO = 1
SELECT TAB_A.* FROM (
SELECT a.*, ROW_NUMBER() OVER( PARTITION BY a.分组字段 ORDER BY a.排序字段 DESC ) ROWNO
FROM 表1 a
) TAB_A
WHERE ROWNO = 1