IT/MS-SQL

MSSQL SELECT절에서 두번째로 높은 값 찾기

withoutWings 2011. 2. 24. 10:51

SELECT MAX([Version])
FROM DeployDtl AS a JOIN DeployLog AS b ON a.DeployID = b.DeployID
WHERE a.ObjectName = @ObjectName 
            AND a.[Version] < (SELECT MAX(Version) FROM DeployDtl
WHERE DeployID = @DeployID AND ObjectName = @ObjectName)