2-correlated-subquery.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 12 行

SELECT ShareId,MaximumSharePrice
FROM ShareDetails.Shares
UPDATE ShareDetails.Shares
SET MaximumSharePrice = (SELECT MAX(Price)
                                           FROM ShareDetails.SharePrices sp
                               WHERE sp.ShareId = s.ShareId)
FROM ShareDetails.Shares s
SELECT ShareId,MaximumSharePrice
FROM ShareDetails.Shares