長這樣

求game_id group by 的得分

select game_id,sum(win) from game_record group by game_id

求game_id group by 的得分200以上

select game_id,sum(win) from game_record group by game_id having sum(win) >200

求每個玩家同一家廠商每款遊戲總得分

select host_id,user_id,game_id,sum(win) from game_record group by user_id,game_id ,host_id

 

arrow
arrow
    全站熱搜

    學習程式 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄