Den 22.01.2016 11:51, skrev Luigi Siciliano luigi...@tiscalinet.it
[firebird-support]:
> 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
Hi,
not so simple as you show but you can do:
1. calculated fields (if fields are from one table)
2. select from select :
SELECT
C
,C*5 AS D
FROM
(
SELECT
2+3 AS C
FROM
RDB$DATABASE
)
but this will be slower then repeated calculation i suppose
regards,
Karol Bieniaszewski
W dniu 2016-01-22