MySQL Distinct Clause

When fetching data from a database table, the result may contain duplicate rows or values. If you want to remove these duplicate values you can specify the keyword DISTINCT.

Selects only the DISTINCT values from the "city" column in the "employees" table:

SELECT DISTINCT city FROM employees;

Lists the number of different employees in different city:

SELECT COUNT(DISTINCT city) FROM employees;