Select Distinct

The SELECT DISTINCT command is used to return rows with unique values based on a specified attribute.

Syntax

SELECT DISTINCT <column-name> FROM <table-name>;

Example #1

SELECT DISTINCT hq FROM Companies;

Example #2

SELECT DISTINCT hq FROM Companies ORDER BY hq;