求mysql两个表的某个列的总和的差

求 a表c列的总和 减 b表d列的总和
2025-05-18 22:50:13
推荐回答(2个)
回答1:

select sum(c) from a

select sum(d) from b

然后两个值手工减一下

回答2:

select aa.cc-bb.dd from (select sum(c) cc from a) as aa,(select sum(d) dd from b) as bb