Count_Distinct() is used to find the number
of distinct non-null field values as mentioned in the query criteria.
of distinct non-null field values as mentioned in the query criteria.
Sample
Query:
Query:
SELECT
COUNT_DISTINCT(City__c) TotalCities FROM Employee__c1
COUNT_DISTINCT(City__c) TotalCities FROM Employee__c1
Below is the output of the above query
execution.
execution.