SQL SELECT DISTINCT

Returns unique values in the specified column(s).

Syntax

The SELECT DISTINCT statement specifies that the statement is going to be a query that returns unique values in the specified column(s).

SELECT DISTINCT column_name
FROM table_name;

Copy to clipboard
Copy to clipboard

Example

For a table teams having five rows:

SELECT DISTINCT city
FROM teams;

Copy to clipboard
Copy to clipboard

The given query would return: