How would you get the count of unique values in a given field?

How would you get the count of unique values in a given field?

 

• COUNT() function with DISTINCT clause
• COUNT() function with UNIQUE clause
• TOTAL() function with DISTINCT clause