Development questions
Write a SOQL query to fetch Accounts that have at least one related Contact (Inner Join / Semi-Join using WHERE Id IN (SELECT AccountId FROM Contact)).
Use a semi-join: WHERE Id IN (SELECT AccountId FROM Contact).
soql
SELECT Id, Name FROM Account WHERE Id IN (SELECT AccountId FROM Contact)
Only Accounts having at least one Contact are returned. The subquery must select a single Id/lookup field.
soqlscenariosemi-join
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?