Find Distinct (Unique) values

The SELECT DISTINCT statement is used to return only distinct (unique) values.


Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.

SELECT DISTINCT column1, column2, ...
FROM table_name;

Author: Dev

Full Stack Developer at one of the largest Banks in Canada.