Question: how to find the unique values in sql?
Answer: SELECT DISTINCT returns only distinct (i.e. different) values.
SELECT DISTINCT eliminates duplicate records from the results.
DISTINCT can be used with aggregates: COUNT, AVG, MAX, etc.
DISTINCT operates on a single column. DISTINCT for multiple columns is not supported.