我将 T-Sql 与 SQL Server 2008 一起使用。假设我有父表:
项目:
ProjectID ProjectNam
1 Test Project 1
2 Test Project 2
和子表项目修订:
ProjectRevID ProjectID DateCreated
11 1 10/15/2009
12 1 10/19/2009
13 1 10/25/2009
21 2 10/05/2009
我如何才能获得每个项目的最新 ProjectRevision?像这样:
ProjectRevID ProjectID DateCreated
13 1 10/25/2009
21 2 10/05/2009
无论 ProjectRevId 和 DateCreated 之间存在任何关系,下面的查询都将起作用。
SELECT *
FROM ProjectRevisions
INNER JOIN (
SELECT ProjectId
, MAX(DateCreated) AS DateCreated
FROM ProjectRevisions
GROUP BY ProjectId
) AS CurrentRevision
ON CurrentRevision.ProjectId = ProjectRevisions.ProjectId
AND CurrentRevision.DateCreated = ProjectRevisions.DateCreated
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)