SELECT DISTINCT

The SELECT DISTINCT statement will return unique values based on the query. If there are multiple rows with the same value only one will be returned and the other will be ignored. The DISTINCT syntax states that all values must be unique. The following is the standard syntax for the statement.

SELECT DISTINCT field1
FROM table1