聚合函数可以在一个SQL相加吗

我想统计5个表的总行数，能否在一个SQL中实现。
SELECT COUNT(*) FROM t1+SELECT COUNT(*) FROM t2+SELECT COUNT(*) FROM t3+SELECT COUNT(*) FROM t4+SELECT COUNT(*) FROM t5.上面5个表结构完全一样，不要用 select count(*) from (select * from t1 union selctt * from t2 union selctt * from t3 union selctt * from t4 union selctt * from t5).
谢谢！

SQL code

select 
(SELECT COUNT(*) FROM t1)+
(SELECT COUNT(*) FROM t2)+
(SELECT COUNT(*) FROM t3)+
(SELECT COUNT(*) FROM t4)+
(SELECT COUNT(*) FROM t5)

SQL code

select 
(SELECT COUNT(*) FROM t1)+
(SELECT COUNT(*) FROM t2)+
(SELECT COUNT(*) FROM t3)+
(SELECT COUNT(*) FROM t4)+
(SELECT COUNT(*) FROM t5)

慢了。

用union all才符合原先的逻辑,
SQL code

select count(*) from 
(
select * from t1 
union all 
selctt * from t2 
union all 
selctt * from t3 
union all 
selctt * from t4 
union all 
selctt * from t5
) t6

SQL code

SELECT COUNT(*) FROM t1+SELECT COUNT(*) FROM t2+SELECT COUNT(*) FROM t3+SELECT COUNT(*) FROM t4+SELECT COUNT(*) FROM t5

實現用sysindexes統計

快你N倍

SQL code

SELECT SUM(rows)
FROM sysindexes 
WHERE indid<2 AND OBJECT_NAME(ID) IN('t1','t2','t3','t4','t5')

以你的5個表為例

高!