Breaking News: Grepper is joining You.com. Read the official announcement!

duplicatedAccounts

Blue-eyed Boar answered on June 4, 2022 Popularity 1/10 Helpfulness 1/10

answer duplicatedAccounts

duplicatedAccounts

Comment

//Retrieve duplicate accounts
AggregateResult[] duplicatedAccounts = [SELECT Name, COUNT(Id) 
                                    FROM Account 
                                    GROUP BY Name 
                                    HAVING COUNT(Id) > 1];

//Set to store names of duplicate accounts
Set<String> accountNames = new Set<String>();

//Loop through our duplicate account names and add them to our set
for (AggregateResult duplicateAccount : duplicatedAccounts)  {
		
	accountNames.add(duplicateAccount.get('Name').toString());
}

//Query accounts to get Ids for our duplicate accounts
List<Account> accounts = [SELECT id, name FROM Account where name IN :accountNames];

System.debug(accounts);

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: www.levelupsalesforce.com

Tags: whatever

Link to this answer
Share Copy Link