Subject | Re: [firebird-support] Using field alias in having clause |
---|---|
Author | Ismael L. Donis García |
Post date | 2008-02-22T15:39:27Z |
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"
=========
¦¦ ISMAEL ¦¦
=========
[Non-text portions of this message have been removed]
"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"
=========
¦¦ ISMAEL ¦¦
=========
[Non-text portions of this message have been removed]