我这样写也是一样的效果
SELECT gcs,
(SELECT COUNT(gcs)
FROM fwd
WHERE fwd.sfqk = 1 and fwd.gcs=gcs) AS aa,
(SELECT COUNT(gcs)
FROM fwd
WHERE fwd.xjaz = 1 and fwd.gcs=gcs) AS bb
FROM fwd
GROUP BY gcs
可是我得到的结果却是这样的
姓名 条件A 条件B
张三 10 20
李四 10 20
王五 10 20
SELECT gcs,
(SELECT COUNT(gcs)
FROM fwd
WHERE fwd.sfqk = 1 and fwd.gcs=gcs) AS aa,
(SELECT COUNT(gcs)
FROM fwd
WHERE fwd.xjaz = 1 and fwd.gcs=gcs) AS bb
FROM fwd
GROUP BY gcs
可是我得到的结果却是这样的
姓名 条件A 条件B
张三 10 20
李四 10 20
王五 10 20
sum(case when 条件B then 1 else 0 end) as [条件B]
from fwd
group by gcs