Subject RE: [firebird-support] conditional on count
Author Alan McDonald
> FB 1.5
>
> 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
>
where count(*) > 1

Alan