ROW_NUM

SELECT  *  FROM

(

(SELECT ROW_NUMBER() OVER (PARTITION BY  字段1，字段2  ORDER BY 　字段3   DESC) AS  TMPID),  *  

FROM  表名

)

WHERE TMPID=1