The SQL SELECT DISTINCT Statement
The SQL SELECT DISTINCT Statement
The SELECT DISTINCT statement is used to return only distinct (different) values.
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
...See more
SELECT DISTINCT Syntax
SELECT DISTINCT column1, column2, ...
FROM table_name;
SELECT Example Without DISTINCT
The following SQL statement selects ALL (including the duplicates) values from the "Country" column in the "Customers" table:
Example
SELECT Country FROM Customers;
Try it Yourself »
Now, let us use the DISTINCT keyword with the above SELECT statement and see the result.
Views: 1155
Added: 4 years ago
The SQL SELECT DISTINCT Statement.docx
Download
Suggested Creators
Answer the Question