You need to sign in to do that
Don't have an account?
Mayank Agarwal 5
SOQL to fetch account name who contains contacts
Hello,
I want to write a SOQL to fetch all those account names which have contacts associted with them.
Also to fetch all those account names which have 10 contacts associted with them.
Thanks,
Mayank
I want to write a SOQL to fetch all those account names which have contacts associted with them.
Also to fetch all those account names which have 10 contacts associted with them.
Thanks,
Mayank
The above will give you lists of Accounts with Contacts and Accounts with 10 Contacts. You can loop through the list to get just the names of the Accounts if you wish.
All Answers
The above will give you lists of Accounts with Contacts and Accounts with 10 Contacts. You can loop through the list to get just the names of the Accounts if you wish.
Thanks for the reply.
But I have one doubt, can this prevent duplicate records also.
Thanks,
Mayank
Thanks for the clearification.
It help me a lot.
Thanks,
Mayank