Upserting RecordsThis example uses upsert and an external ID field Line_Item_Id__c on the Asset object to maintain a one-to-one relationship between an...
Using Joins in SOQLSemi-Joins with IN: Eg, query using objects - Account and Opportunity, SELECT Id, Name FROM Account WHERE Id IN ( SELECT AccountId FROM...
Data Quality ManagementTo return duplicate Account/Contact/Lead names: select name, count(id) from <Account/Contact/Lead> group by name having count(id) > 1 To...
Comments