如何用1句sql得到两个查询结果的和?

来源：百度知道 编辑：UC知道 时间：2024/05/11 00:22:05
SELECT COUNT(DISTINCT ScenarioID) AS Expr1
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID = '2007.1.0a9') AND
(ExecutionType = 'automated') AND (Environment IN ('Win3/orcl'))

SELECT COUNT(DISTINCT ScenarioID) AS Expr2
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID = '2007.1.0a9') AND
(ExecutionType = 'automated') AND (Environment IN ('Win3/sql5'))
我需要得到expr1+expr2,但要写到一句sql里...
我需要的是一个结果 不是两个....

SELECT COUNT(DISTINCT ScenarioID) AS Expr1
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID = '2007.1.0a9') AND
(ExecutionType = 'automated') AND (Environment IN ('Win3/orcl'))
UNPON
SELECT COUNT(DISTINCT ScenarioID) AS Expr2
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID = '2007.1.0a9') AND
(ExecutionType = 'automated') AND (Environment IN ('Win3/sql5'))

select
(SELECT COUNT(DISTINCT ScenarioID) AS Expr1
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID = '2007.1.0a9') AND
(ExecutionType = 'automated') AND (Environment IN ('Win3/orcl')) )+
(SELECT COUNT(DISTINCT ScenarioID) AS Expr2
FROM TestTable
WHERE (TestDate BETWEEN '5/28/2007' AND '5/30/2007') AND (BuildID