Subject | Re: [firebird-support] Using field alias in having clause |
---|---|
Author | Uwe Grauer |
Post date | 2008-02-22T18:53:56Z |
Ismael L. Donis GarcĂa wrote:
Uwe
> 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