如何在多个公共表达式
中使用UNION
?
我正在尝试汇总一些数据,但无论我在哪里放置;
,都会出现错误。
SELECT COUNT(*)
FROM dbo.Decision_Data
UNION
SELECT COUNT(DISTINCT Client_No)
FROM dbo.Decision_Data
UNION
WITH [Clients]
AS ( SELECT Client_No
FROM dbo.Decision_Data
GROUP BY Client_No
HAVING COUNT(*) = 1
)
SELECT COUNT(*) AS [Clients Single Record CTE]
FROM Clients;
我很感激上面的例子中我可以将单个CTE移动到开头,但我有很多CTE我想要UNION