Toggle Side Panel

  • Blogs
  • Consultants
    • Salesforce Product Expertise
      • Top Salesforce ConsultantsTop Salesforce Consultants
      • Marketing Cloud ConsultantsMarketing Cloud Consultants
      • Service Cloud ConsultantsService Cloud Consultants
      • Experience Cloud ConsultantsExperience Cloud Consultants
      • Analytics Cloud ConsultantsAnalytics Cloud Consultants
    • Salesforce Industry Expertise
      • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
      • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
      • Health Cloud ConsultantsHealth Cloud Consultants
      • Commerce Cloud ConsultantsCommerce Cloud Consultants
      • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
    • Salesforce Experts by Location
      • USATop Salesforce Consultants in USA
      • IndiaTop Salesforce Consultants in India
      • AustraliaTop Salesforce Consultants in Australia
      • United KingdomTop Salesforce Consultants in UK
      • CanadaTop Salesforce Consultants in Canada
  • Webinars
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Blogs
    • Consultants
      • Salesforce Product Expertise
        • Top Salesforce ConsultantsTop Salesforce Consultants
        • Marketing Cloud ConsultantsMarketing Cloud Consultants
        • Service Cloud ConsultantsService Cloud Consultants
        • Experience Cloud ConsultantsExperience Cloud Consultants
        • Analytics Cloud ConsultantsAnalytics Cloud Consultants
      • Salesforce Industry Expertise
        • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
        • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
        • Health Cloud ConsultantsHealth Cloud Consultants
        • Commerce Cloud ConsultantsCommerce Cloud Consultants
        • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
      • Salesforce Experts by Location
        • USATop Salesforce Consultants in USA
        • IndiaTop Salesforce Consultants in India
        • AustraliaTop Salesforce Consultants in Australia
        • United KingdomTop Salesforce Consultants in UK
        • CanadaTop Salesforce Consultants in Canada
    • Webinars
    • Contact Us
    • Discussions
    Close search

    Activity › Forums › Salesforce® Discussions › Salesforce Query to Get the list of accounts where Related contacts Greater than 200

    Tagged: Account List, Account List in Salesforce, Accounts in Salesforce, Contact List in Salesforce, Contact Object, Contact Record, Salesforce List, Salesforce Object Query Language, Salesforce Query

    • Salesforce® Discussions

      Salesforce Query to Get the list of accounts where Related contacts Greater than 200

      Posted by subramanyam subbu on January 31, 2018 at 3:40 PM

      hi all,

      Is it possible to write a query to get a list of accounts where associated contacts greater than 200?

      Mohit replied 8 years, 9 months ago 2 Members · 1 Reply
      • Account List
      • Account List in Salesforce
      • Accounts in Salesforce
      • Contact List in Salesforce
      • Contact Object
      • Contact Record
      • Salesforce List
      • Salesforce Object Query Language
      • Salesforce Query
    • 1 Reply
    • Mohit

      Member
      February 1, 2018 at 9:38 AM

      Hi Subramanyam Subbu,
      Yes, it is possible to query the list of Accounts where Associated Contacts greater than 200.
      For this, we can use the Aggregate query to fetch the AccountId of those Account record having related contact greater than 200.
      Here is the Code below:-

      AggregateResult[] groupedResults = [select AccountID from Contact GROUP BY AccountID HAVING count(AccountId)>200];

      for (AggregateResult ar : groupedResults) {

      System.debug('Account ID' + ar.get('AccountID'));

      }
      Hope this may help you.

      Thanks,
      Mohit Agarwal

    Log In to reply.

    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me

    Popular Salesforce Blogs

    5 Top Benefits of Using Salesforce CRM for Banks in 2023

    Blog in Salesforce

    A CEO of a well-known investment bank once remarked proper use of technology is the cornerstone of success of a modern financial organization, and rightly…

    Bank, Bankers, Banking, Banking Companies, Banking Industry
    Solunus Jan 6, 2023
    3,527  Views

    Detailed Overview of Salesforce Einstein 1 Studio

    Blog in Salesforce Einstein

    In the recent stage of AI growth, customization has been at the forefront of innovation. Salesforce has made an advancement in this trend, presenting Einstein…

    Einstein Analytics, Einstein Bot, Einstein Discovery, Salesforce Consulting, Salesforce Development
    Sparkybit Aug 1, 2025
    828  Views

    Salesforce Flows - What You Need to Know

    Blog in Salesforce

    Businesses strive to grow bigger and better, but the amount of complex processes becomes trickier to manage without a reliable system that can streamline multiple…

    Application, Automating Repetitive Tasks, automation tools, Business, Business Efficiency
    Apphienz Jan 5, 2022
    2,862  Views

    Popular Salesforce Videos

    Transition to Salesforce Lightning Experience

    Transition to Salesforce Lightning Experience

    Video in Lightning

    Transition to Salesforce Lightning Experience for Overall Navigation, Global Search, Home Page, Accounts, Leads and Opportunities. This video walks you through the recommended process, including…

    Salesforce Lightning, Lighting Design, Leads in Salesforce, Lightning Components, Lightning Experience Considerations
    Ashley Mar 6, 2018
    2,085  Views
    2020 Salesforce Admin Certification - Lightning Knowledge Base Setup

    2020 Salesforce Admin Certification - Lightning Knowledge Base Setup

    Video in Salesforce Certifications

    A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…

    Salesforce Certification, Salesforce Lightning, Salesforce Administrator, Salesforce Admin, Salesforce Video
    Abhishek Oct 16, 2020
    2,300  Views
    Mission Mangal | Build a Mars Communication Uplink | Salesforce Tutorials | Mini Project

    Mission Mangal | Build a Mars Communication Uplink | Salesforce Tutorials | Mini Project

    Video in Salesforce Development

    In this video, you will learn to create a Mars Communication Uplink using Salesforce. We will create a communication system from Rovers on Mars. Interesting…

    Salesforce Training, Salesforce Developer, Salesforce Tutorials, Salesforce Video, Salesforce Learning
    Kapil Jun 22, 2020
    2,570  Views
    Footer Forcetalks logo

    support@forcetalks.com

    • twitterx

    Quick Links

    Advertise with Us

    Salesforce® Articles

    Dreamforce 2023

    Top Salesforce® Bloggers 2023

    Top Salesforce Consultants

    Get Listed

    Company

    Contact Us

    About Us

    Privacy Policy

    Terms & Conditions

    InsightHub

    Salesforce Blogs

    Salesforce Videos

    Salesforce Groups

    Salesforce Jobs

    © 2026 - Forcetalks ● All Rights Reserved

    Salesforce® is a trademark of Salesforce® Inc. No claim is made to the exclusive right to use “Salesforce”. Any services offered within the Forcetalks website/app are not sponsored or endorsed by Salesforce®.

    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.