我寫了一個像這樣的子查詢：
(
SELECT SUM(X.kMax)
FROM (
SELECT MAX(Val) AS kMax
FROM [Consumers] upc
GROUP BY upc.[Profile]
) X
)
它獲取每個組態檔的最大值，然后將所有內容相加以回傳一個值。例如 99
我將如何將此值應用于外部查詢中的每一行？
Table
ID Maxed
1 99
2 99
3 99
4 99
5 99
uj5u.com熱心網友回復：
你需要像followng一樣寫你的查詢。
select
<columns>,
(
SELECT SUM(X.kMax)
FROM (
SELECT MAX(Val) AS kMax
FROM [Consumers] upc
WHERE UPC.ID=UT.ID
GROUP BY upc.[Profile]
) X
)
from yourTable ut
uj5u.com熱心網友回復：
您可以使用或應用一個值CROSS APPLYOUTER APPLY
select
<columns>,
X.kMax
from yourTable T
CROSS APPLY (
SELECT SUM(X.kMax) AS kMax
FROM (
SELECT MAX(Val) AS kMax
FROM [Consumers] upc
WHERE UPC.ID=UT.ID
GROUP BY upc.[Profile]
) X
) X
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/313284.html
標籤：sql-server 查询语句 标量子查询
上一篇：SQLServer-sys.tables中所有特定列的記錄數
下一篇：SQLLEFTJOIN到許多類別