嗨,我使用mysql視窗函數計算每個産品的利潤占總利潤的百分比。但是,它并不像我所期望的那樣工作。
資料:表A
total Profit productCode productName
5554.56 S10_1949 1952 Alpine Renault 1300
5473.71 S12_4675 1969 Dodge Charger
5078.35 S12_1108 2001 Ferrari Enzo
4475 S12_1099 1968 Ford Mustang
我的密碼
select A.totalProfit,
A.totalProfit/sum(A.totalProfit) over (PARTITION BY A.totalProfit) as profitPercent,
A.productCode, A.productName
from A;
我得到的輸出,利潤率計算不正确
totalProfit profitPercent productCode productName
5554.56 1 S10_1949 1952 Alpine Renault 1300
5473.71 1 S12_4675 1969 Dodge Charger
5078.35 1 S12_1108 2001 Ferrari Enzo
4475 1 S12_1099 1968 Ford Mustang
預期産量
totalProfit profitPercent productCode productName
5554.56 0.26987963 S10_1949 1952 Alpine Renault 1300
5473.71 0.265951368 S12_4675 1969 Dodge Charger
5078.35 0.246741996 S12_1108 2001 Ferrari Enzo
4475 0.217427005 S12_1099 1968 Ford Mustang
對我的代碼有什麼建議嗎?謝謝