sql 对多个sql count的值再求和

select (select count() from bumen)+(select count() from mrs) as sum_count
如果两个表结果相同的话,也可以用
select count(*) as sum_count
from
(
select * from A
union all
select * from B
) as tmp

sql查询单表之中大于2条的数据
SELECT COUNT(字段)AS COUNT,字段FROM 表名 GROUP BY 字段 HAVING COUNT >=2