> I was hoping someone could help here. I have a table with two columns, > one called 'person_name' and the other called 'number'. A person can > have more than one number and I want the query to return all person's > that have more than 3 numbers.
Try this: SELECT person_name FROM table GROUP BY person_name HAVING COUNT(number) > 3 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3144 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
