摘要： 1:依某字段分组取最大记录值的所有数据select * from Attachment a ,(select max(edition) edition,docno from Attachment group by docno) b where a.edition=b.edition and a.docno=b.docno order by filename,uploadtime 阅读全文