-
What is the Limit for record retrieve in a Salesforce subquery ?
List<Account> acc=[select name (select LastName from contacts) from Account Limit 10];
Suppose i am fetching records from account and i am fetching contacts associated with each Account in a subquery then what is the limit of fetching contacts
-
1 Reply
-
This point can help you understand this:
In a SOQL query with parent-child relationship subqueries, each parent-child relationship counts as an extra query. These types of queries have a limit of three times the number for top-level queries. The row counts from these relationship queries contribute to the row counts of the overall code execution.
So, Total number of records retrieved by SOQL queries would be 50,000 altogether.
Log In to reply.
Popular Salesforce Blogs
Marketing Success Post Pandemic | Salesforce Success Guide
From everything the world has experienced so far, the pandemic has led to two paths—complete paralysis of the business or a springboard towards success. Simply…
Odoo ERP System Implementation in the United States
In 2026, U.S.-based businesses face mounting pressure to streamline operations, reduce costs, and leverage data for strategic decision-making. With competition intensifying across industries—manufacturing, retail, healthcare,…
Fixing Customer Follow-Up Delays Using Salesforce Sales Cloud Automation
Customer follow-up delays continue to be a major issue for sales teams. A recent industry study reported that 48% of sales opportunities fail due to…
Popular Salesforce Videos
Welcome to the New World of Data Collection | Salesforce | Summer Internship
Secure data collection built for your needs. With FormAssembly, your organization can streamline outdated processes and power important business initiatives. To enroll Contact us +91…
Salesforce Lightning Events Tutorial I Building Component Events (Single Component)
This Salesforce Lightning Events Tutorial will make you learn how to register an event in Salesforce Lightning and handle that event in the source component…
Control Access to the Org | Data Security | Salesforce
In this video, wonder Studies explains how to control access to your Salesforce org and the data security measures you can take to protect your…
