On account , we have contact. There is a custom object called employee having lookup on contact and custom field called salary. I want to display the sum of all employee salaries on account record . Can we write an soql query for this?

Question

Rajamohan Vakati · Answer

Try this..  Select Sum (sal__c) from Employee__c groupBy Contacts.AccountID__c

On account , we have contact. There is a custom object called employee having lookup on contact and custom field called salary. I want to display the sum of all employee salaries on account record . Can we write an soql query for this?

Apex

Formation associée

Aide supplémentaire