SELECT * FROM
(
(SELECT ROW_NUMBER() OVER (PARTITION BY 字段1，字段2 ORDER BY 字段3 DESC) AS TMPID), *
FROM 表名
)
WHERE TMPID=1