pda4me
asked on
MySQL query pull data greater than 20
i have a table called agent. this table has a field called officeName.
How do I select all distinct officeName where there are more than 20 instances of agents for that office?
How do I select all distinct officeName where there are more than 20 instances of agents for that office?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
shouldn't need the distinct with the group by
ASKER
Worked AWESOME!
select distinct(officename) from agent group by officename having count(*) > 20