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__c1

Below is the output of the above query execution.

No comments:

Post a Comment

Sharing is Caring!!! Share this with your friends!!!

submit to reddit