SQL中某一列的值为条件中最大的筛选
有一个表的结构
projectID Project version
1 projectA 1
1 projectA 2
1 projectA 3
2 projectB 1
2 projectB 2
3 projectc 1

能把最大的Version查出来吗.?
得到结果
projectID Project version
1 projectA 3
2 projectB 2
3 projectc 1
[解决办法]
select projectID , Project,max(version)
from tb
group by
projectID , Project
[解决办法]

SELECT   Projectid,
         Project,
         Max(version)
FROM     tab
GROUP BY Projectid,
         Project

select projectID,Project,max(version) as version from tb group by projectID ,Project