Question

sql函数，select count(A.abc) as sum from A left join B on A.id=B.id where A.abc='1' group by A.abc

结果是 sum
2
3
4

怎么求count(A.abc) as sum 的总数。

Answer 1

SELECT
SUM ( t.iSum ) as sum
FROM
(
select count(A.abc) as iSum from A left join B on A.id=B.id where A.abc='1' group by A.abc

);

或者

select count(A.abc) as sum from A left join B on A.id=B.id where A.abc='1'

Answer 2

去掉group by就是总数了

Answer 3

select count(A.abc) as sum from A left join B on A.id=B.id where A.abc='1'