Subject | RE: [firebird-support] conditional on count |
---|---|
Author | Alan McDonald |
Post date | 2007-02-10T22:44:03Z |
> FB 1.5where count(*) > 1
>
> I would like to run the following SQL:
>
> select CustomPlan_ID, count(*) as ItemCount
> from CustomPlanInfo
> where ItemCount > 1 <<-- doesn't work
> group by 1
>
> But it doesn't like ItemCount. Is there a way to do this?
>
> Thanks,
> Ed Dressel
>
Alan