DISTINCT

Applies to: sql

DISTINCT removes duplicate rows from a result, returning only unique values, handy for listing the set of values that appear in a column.

SELECT DISTINCT country FROM customers;

See also: select, group-by