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. 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.

The SQL SELECT DISTINCT Statement +2 more

by yash sharma

Stash 0

1 Attachment 4 years ago