在SQL中,我有一组查询,它们返回具有不同条件的不同表中的计数值,如下所示
SELECT COUNT(DISTINCT GroupUserID) AS KnownUsers
FROM Table A
WHERE ...
SELECT COUNT(DISTINCT GroupUserID) AS UnKnownUsers
FROM TableB
WHERE (a different condition)
SELECT
COUNT(DISTINCT ManagerID) AS Managers,
COUNT(DISTINCT LeadID) AS TeamLeads
FROM
TableX
WHERE
(condition)有没有什么方法或查询可以用来将所有3个SQL查询组合成一个返回4列的查询?
KnownUsers UnKnownUsers Managers TeamLeads发布于 2017-08-22 17:30:39
尝尝这个
SELECT (select COUNT(distinct GroupUserID) as KnownUsers from Table A WHERE ...) as KnownUsers ,
(SELECT COUNT(distinct GroupUserID) as UnKnownUsers from TableB WHERE (a different condition)) as UnKnownUsers,
(SELECT COUNT(distinct ManagerID) from TableX WHERE (condition)) as Managers,
(SELECT COUNT(distinct LeadID) as TeamLeads from TableX WHERE (condition)) as TeamLeads 发布于 2017-08-22 17:33:00
是。使用子查询选择它们:
SELECT
KnownUsers=(SELECT COUNT(distinct GroupUserID) from Table A WHERE ...),
UnKnownUsers=(SELECT COUNT(distinct GroupUserID) from TableB WHERE (a different condition)),
Managers=(SELECT COUNT(distinct ManagerID) from TableX WHERE (condition)),
TeamLeads=(SELECT COUNT(distinct LeadID) from TableX WHERE (condition));发布于 2017-08-22 18:06:56
select *
from
(
select COUNT(1) TotalRecord,'KnownUsers' as Users from TableA
union all
select COUNT(1) TotalRecord,'UnKnownUsers' as Users from TableB
union all
select COUNT(1) TotalRecord,'TeamLeads' as Users from TableX
union all
select COUNT(1) TotalRecord,'Managers' as Users from TableX
)
UserDetails
pivot
(
sum(TotalRecord)
for Users in ([KnownUsers], [UnKnownUsers], [TeamLeads], [Managers])
) piv;https://stackoverflow.com/questions/45813796
复制相似问题