Subject | Re: [firebird-support] Using field alias in having clause |
---|---|
Author | Ismael L. Donis García |
Post date | 2008-02-22T19:36:48Z |
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:
Uwe
[Non-text portions of this message have been removed]
=========
¦¦ 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 ofI don't understand what you want to tell me.
>
> "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"
Uwe
[Non-text portions of this message have been removed]