22,209
社区成员
发帖
与我相关
我的任务
分享
select * from
(select 专业,原因类型,状态,COUNT(A1) as A1
from tablename
where A1='T'
group by 专业,原因类型,状态) as a join
(select 专业,原因类型,状态,COUNT(A2) as A1
from tablename
where A2='T'
group by 专业,原因类型,状态) as b
on a.专业=b.专业 and
a.原因类型=b.原因类型 and
a.状态=b.状态
SELECT
[专业]
,[原因类型]
,[状态]
,SUM(CASE[A1]WHEN'T'THEN 1 ELSE 0 END)A1
,SUM(CASE[A2]WHEN'T'THEN 1 ELSE 0 END)A2
FROM
tablename
GROUP BY
[专业]
,[原因类型]
,[状态]
你参考一下