| 國籍 | 價值 | 支柱 |
|---|---|---|
| n1 | 1000 | |
| n1 | 2000 | |
| n2 | 2000 | |
| n3 | 3000 | |
| n3 | 3000 |
結果
| 國籍 | 價值 | 支柱 |
|---|---|---|
| n1 | 3000 | 27,27% |
| n2 | 2000 | 18,18% |
| n3 | 6000 | 54,54% |
uj5u.com熱心網友回復：
| 國籍 | 價值 | 支柱 |
|---|---|---|
| n1 | 1000 | |
| n1 | 2000 | |
| n2 | 2000 | |
| n3 | 3000 | |
| n3 | 3000 |
結果
| 國籍 | 價值 | 支柱 |
|---|---|---|
| n1 | 3000 | 27,27% |
| n2 | 2000 | 18,18% |
| n3 | 6000 | 54,54% |
uj5u.com熱心網友回復：
嘗試以下操作：
select distinct nationality,
sum(value_eur) over (partition by nationality) as Value ,
1.0 * sum(value_eur) over (partition by nationality)/(select sum(value_eur) from MyData) as Prob
from MyData
請參閱db-fiddle的演示。
uj5u.com熱心網友回復：
試試這個：
WITH cte AS (
SELECT nationality,
SUM(value_eur) AS Value_
FROM Fifadf
GROUP BY nationality
)
SELECT nationality,
Value_,
Value_ / SUM(Value_) OVER() AS Prop
FROM cte
在此處查看演示。
uj5u.com熱心網友回復：
你不需要CTE這個。
select Nationality, sum(value_eur) as Value, 1.0 * sum(value_eur)/sum(value_eur) as Prop
from Fifadf
group by nationality
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/497182.html