sql 两个表记录数求和

最新推荐文章于 2023-09-22 10:20:44 发布

丽个啷个江

最新推荐文章于 2023-09-22 10:20:44 发布

阅读量1w

点赞数 3

分类专栏：工作日志

本文链接：https://blog.csdn.net/lijiang_shen/article/details/108623140

版权

工作日志专栏收录该内容

16 篇文章 4 订阅

订阅专栏

union all

SELECT COUNT(s_id) as emuRS from sea_wave_heigth 
union all SELECT COUNT(s_id) from sar_wake
union all SELECT COUNT(f_id) from wake_infrared
union all SELECT COUNT(v_id) from wake_visible_light
union all SELECT COUNT(dunker_id) from emulate_goal_dunker
union all SELECT COUNT(w_id) from wake_water_power

在这里插入图片描述

对上面的查询结果求和：

SELECT (SELECT COUNT(s_id)  FROM sea_wave_heigth)
		+ (SELECT COUNT(s_id)  FROM sar_wake)
		+ (SELECT COUNT(f_id)  from wake_infrared)
		+ (SELECT COUNT(v_id)  from wake_visible_light)
		+ (SELECT COUNT(dunker_id)  from emulate_goal_dunker)
		+ (SELECT COUNT(w_id) from wake_water_power)emuRS