Subject | Is it possible calculate result of aggregates? |
---|---|
Author | Luigi Siciliano |
Post date | 2016-01-22T10:51:43Z |
How can I do this query:
Select
A,
B,
SUM(A + B) as C,
C * A as D ----->>>>> FB result on "C not Exists" error!
from
table
group by
A,
B
Of course, I can do this: "SUM(A + B) * A as D" to perform my query but,
I wish to learn if is possible the other one (C * A as D)
Thanks.
--
Luigi Siciliano
--------------------------
Select
A,
B,
SUM(A + B) as C,
C * A as D ----->>>>> FB result on "C not Exists" error!
from
table
group by
A,
B
Of course, I can do this: "SUM(A + B) * A as D" to perform my query but,
I wish to learn if is possible the other one (C * A as D)
Thanks.
--
Luigi Siciliano
--------------------------