sql计算两表相同列的和原创
原创问:如下表所示a,b,求num列的和
表a:
id
num
1
10
2
15
3
20
表b:
id
num
1
5
2
10
3
15
4
20
求num列中,结果如下:
id
sum(num)
1
15
2
25
3
35
4
20
解决方案:
select id,sum(num) as sum(num) from (select a.id,a.num from a union all select b.id,b.num from b) c GROUP BY id
结果:

版权声明
所有资源都来源于爬虫采集,如有侵权请联系我们,我们将立即删除
相关文章
最新文章
- Stabyourself.net Games 45分钟前
- 【IT 早报】2026年11月19日 - 本周要闻与趋势 49分钟前
- 从均匀平铺到自适应路由:RINs 如何让扩散生成提速 10 倍? 2小时前
- Claude Code makes a finished subagent send its report twice (70-second repro) 2小时前
- Becerra faces a $2B budget deficit as potential AI bust looms 2小时前
- Show HN: Agent Hive – cute Grokbot like agentic teams with queen and many bees 3小时前
- Show HN: Lazycow Studio – turns footage you never edited into reels, locally 3小时前
- Experiments in Weight-Space Programming 3小时前
- Lindy Effect 3小时前
- Meet Your Neighbors – A new type of political compass 5小时前
itfan123


