Column-wise total in Oracle Query

Question

Hi all...

 

This is my query (Helped By Mr. Manoj) in previous post....

 

Select *, (x.A+x.B-x.C) as "D" From (

select E.EmpCode,

(select count (D.id) from Dept D where D.Location = E.Location) as "A"),

(select count (D.id) from Add D where D.Location = E.Location) as "B"),

(select count (D.id) from Dept D where D.DeptName = E.DeptName) as "C")

from Employees E) x

 

Now ; in this query ; How do I get column-wise total ??

 

Data -

 

EmpCode	A	B	C	D=A+B-C
100A	2	4	7	2+4-7 = -1
101A	3	5	7	3+5-7 = 1

 

I want -

A = 2+3 = 5 ; B = 4+5 = 9 ; C = 7+7 = 14 ; D = -1 + 1 = 0

in the last record...

 

Please guide...