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

--------------------------