How to find number of unique values in table?

Using mysql query we can find the distinct values find the below query for your reffrence


SELECT COUNT (DISTINCT empname) FROM emp;