我如何从两个不同的表(叫他们tab1和tab2)选择计数(*)有作为结果:
Count_1 Count_2
123 456
我试过了:
select count(*) Count_1 from schema.tab1 union all select count(*) Count_2 from schema.tab2
但我所拥有的只有:
Count_1
123
456
我如何从两个不同的表(叫他们tab1和tab2)选择计数(*)有作为结果:
Count_1 Count_2
123 456
我试过了:
select count(*) Count_1 from schema.tab1 union all select count(*) Count_2 from schema.tab2
但我所拥有的只有:
Count_1
123
456
当前回答
选择 (select count() from tab1 where field like 'value') + (select count() from tab2 where field like 'value') 数
其他回答
其他略有不同的方法:
with t1_count as (select count(*) c1 from t1),
t2_count as (select count(*) c2 from t2)
select c1,
c2
from t1_count,
t2_count
/
select c1,
c2
from (select count(*) c1 from t1) t1_count,
(select count(*) c2 from t2) t2_count
/
SELECT (
SELECT COUNT(*)
FROM tab1
) AS count1,
(
SELECT COUNT(*)
FROM tab2
) AS count2
FROM dual
select (select count(*) from tab1) count_1, (select count(*) from tab2) count_2 from dual;
--============= FIRST WAY (Shows as Multiple Row) ===============
SELECT 'tblProducts' [TableName], COUNT(P.Id) [RowCount] FROM tblProducts P
UNION ALL
SELECT 'tblProductSales' [TableName], COUNT(S.Id) [RowCount] FROM tblProductSales S
--============== SECOND WAY (Shows in a Single Row) =============
SELECT
(SELECT COUNT(Id) FROM tblProducts) AS ProductCount,
(SELECT COUNT(Id) FROM tblProductSales) AS SalesCount
Declare @all int
SET @all = (select COUNT(*) from tab1) + (select count(*) from tab2)
Print @all
or
SELECT (select COUNT(*) from tab1) + (select count(*) from tab2)