Subject Re: [firebird-support] Using field alias in having clause
Author Ismael L. Donis García
ent_count for count(*) changes

=========
¦¦ ISMAEL ¦¦
=========
----- Mensaje original -----
De: Uwe Grauer
Para: firebird-support@yahoogroups.com
Enviado: viernes, 22 de febrero de 2008 01:53
Asunto: Re: [firebird-support] Using field alias in having clause


Ismael L. Donis García wrote:
> You take the place of
>
> "SELECT E_TOK, E_VAL, count(*) as ent_count
> FROM ENUM
> group by E_TOK, E_VAL
> having ent_count > 1"
>
>
> FOR
>
> "SELECT E_TOK, E_VAL, count(*) as ent_count
> FROM ENUM
> group by E_TOK, E_VAL
> having count(*) > 1"

I don't understand what you want to tell me.

Uwe





[Non-text portions of this message have been removed]