February 11, 2014

How to count distinct values of field from an object in Salesforce?

Count_Distinct() is used to find the number of distinct non-null field values as mentioned in the query criteria.

Sample Query:
SELECT COUNT_DISTINCT(City__c) TotalCities FROM Employee__c

Below is the output of the above query execution.

No comments:

Post a Comment