多个count查询,计算总计有多少数量
UNION ALL和UNION区别
UNION会自动去重,UNION ALL不会,例如:以下面SQl为示例,子SQL中两个count结果都为1
UNION 展示结果
cSum |
1 |
UNION ALL展示结果条数据
cSum |
1 |
1 |
select SUM(a.c) AS cSum from
(select count(1) AS c from student
UNION ALL
select count(1) AS c from teacher) a