数据库分组选 第一条

SELECT  *
FROM    (
          SELECT   KNOWLEDGE_OID,
                    ROW_NUMBER() OVER ( PARTITION BY KNOWLEDGE_OID ORDER BY LATEST_SCORE DESC ) rid
          FROM      T_REPORT_SCORE
        ) AS t
WHERE   rid = 1