SQL查询一个表中类别字段中Max()最大值对应的记录

 

SQL查询一个表中类别字段中Max()最大值对应的记录

SELECT A.id,
       A.name,
       A.version
FROM   DOC A,
       (SELECT id,
               MAX(version) AS version
        FROM   DOC
        GROUP  BY id) AS B
WHERE  A.id = B.id
       AND A.version = B.version