I need to pull a list of all our Customers that have multiple contacts in key positions. As an example, if a company has more than one Accounting Contact listed I want them returned in the search. Can I use a formula to count the email contacts and return only the ones that have more than one? How?
Basically I need to translate this into a search:
select x.* from ( select users_id, count(user_id) as thecount FROM users group by user_id ) as x where x.thecount > 1
thanks.