Re: [SQL ] 投票結果統計

看板Database作者danielguo (Daniel Guo)時間13年前 (2011/01/04 18:13)推噓1(1推 0噓 0→)

留言1則, 1人參與討論串2/2 (看更多)

SELECT t.`idno` AS `TOPICID`, SUM(IF(p.`vote` = 'A', 1, 0)) AS `A_votes`, SUM(IF(p.`vote` = 'B', 1, 0)) AS `B_votes` FROM `topic` t LEFT JOIN `poll` p ON t.`idno` = p.`topicid` GROUP BY t.`idno` -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 71.84.58.153

推

magicfx

01/04 23:55, , 1^F

01/04 23:55, 1^F

‣ 返回看板[ Database ] 資庫

‣ 更多 danielguo 的文章

文章代碼(AID): #1D8lBNfo (Database)