多条记录求和问题

下面语句sql server与oracle均适用:

select sum(A+B+C)
AS D
from ...
where ...
group by ...