这个表里，我要取每个dwg_id中最大的rev_id那行的内容

比如上面这张表，我要得到的结果就是(42723,9,1)和（42769,0,#）这两行

请问应该怎么写呢？谢谢！@

试试这个
StrSQL = "Select A.* from A inner join (Select [dwg_id],Max([rev_id]) as [rev_id] from A Group By [dwg_id]) as B on " & _
         "B.[dwg_id] = A.[dwg_id] and B.[rev_id] = A.[rev_id]"

表名是revision

Select dwg_id,rev_id,rev_no from revision inner join (Select dwg_id,Max(rev_id) as rev_id from revision Group By dwg_id) as B on B.dwg_id = revision.dwg_id and B.rev_id = revision.rev_id;

报错Ora-00905： missing keyword

你把2楼的例中表名A换成revision

StrSQL = "Select revision.* from revision inner join (Select [dwg_id],Max([rev_id]) as [rev_id] from revision Group By [dwg_id]) as B on " & _
         "B.[dwg_id] = revision.[dwg_id] and B.[rev_id] = revision.[rev_id]"

且学且珍惜，得认学习真正消化

在sql server软件里面建表，然后用sql语句调试，进行查询分析正确的结果。试试上面给出的sql语句。貌似正确。

学习了，正在学数据库。