The SELECT DISTINCT Statement

The DISTINCT keyword is used to return only distinct (different) values.

The SELECT statement returns information from table columns. But what if we only want to select distinct elements?

With SQL, all we need to do is to add a DISTINCT keyword to the SELECT statement:

Syntax

Using the DISTINCT keyword

To select ALL values from the column named "Company" we use a SELECT statement like this:

"Orders" table

Note that "W3Schools" is listed twice in the result-set.

Result:

Now "365edu" is listed only once in the result-set.