Subject | conditional on count |
---|---|
Author | Ed Dressel |
Post date | 2007-02-10T22:30:29Z |
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
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