※ 引述《SmallBeeWayn (喵喵叫的蜜蜂貓)》之銘言：
: 系統: MySQL 4.1 & PHP 5
: 資料庫大致呈現這個形式
: 也就是說計算出每個人在每個Round的RV => (Votes/(同個Round的SUM))
沒有實際驗證，或許需要修改
Method 1.
select a.Name , a.Round , (a.Votes/b.T_Votes)
from db as a,(
select Round,sum(Votes) as T_Votes from db group by Round
) as b
where a.Round=b.Round
Method 2.
select X.Name , X.Round ,
X.Votes/(select sum(Y.Votes) from db as Y where Y.Round=X.Round )
from db as X
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.160.27.147