Oracle sql 对多个sql count的值再求和

最近写需求，第一次遇到对多个sql count的值再进行求和，赶紧做个笔记~对多个sql count的值再求和：select count(1) countnum from user c where c.NAME = '张三'UNION ALLselect count(1) countnum from contact m where m.MOBILE = '10211325601'UNION ALL

卖火柴的小姑凉呀~~

4305人浏览 · 2021-09-15 10:16:20

卖火柴的小姑凉呀~~ · 2021-09-15 10:16:20 发布

对多个sql 进行count计算后，需要对count出的值再做求和
对多个sql count的值再求和：

SELECT SUM(countnum) FROM (
select count(1) countnum from user c where c.NAME = '张三'
UNION ALL 
select count(1) countnum from contact m where m.MOBILE = '10211325601'
UNION ALL
select count(1) countnum from cert n where n.CERT_NO = '123'
)