Question

似乎很简单: 我有两票,我想看到哪些国家拥有不同的票数。单独而言,这非常容易:

select state, sum(votes) from votes_a group by state;

select state, sum(votes) from votes_b group by state;

对于有不同结果的国家,我如何问及诸如<条码>、选票_a、选票_b

Answer 1

加入:

SELECT
    totals_a.state,
    totals_a.total_votes,
    totals_b.total_votes
FROM
(
    SELECT state, SUM(votes) AS total_votes
    FROM votes_a
    GROUP BY state
) AS totals_a
JOIN
(
    SELECT state, SUM(votes) AS total_votes
    FROM votes_b
    GROUP BY state
) AS totals_b
ON totals_a.state = totals_b.state
WHERE totals_a.total_votes <> totals_b.total_votes

请注意,这将错失在表内获得零票的国家。为了确定这一点,你可以使用“未来”组织(假设你的数据库支持这一特征),并检查“民族解放军”。

Answer 2

......

select state, sum(votes_a), sum(votes_b)
from (select state, sum(votes) votes_a, 0 votes_b
      from votes_a 
      group by state) tbl_a
     (select state, 0 votes_a, sum(votes) votes_b
      from votes_b
      group by state ) tbl_b
where tbl_a.state = tbl_b.state
group by state

友情链接