# 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.
#### SELECT DISTINCT Syntax
```sql
SELECT DISTINCT column1, column2, ...
FROM table_name;
```
The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:
**SELECT**
The following SQL statement selects all (and duplicate) values from the "Country" column in the "Customers" table[ยป](https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_no_distinct)
```sql
SELECT Country FROM Customers;
```
Now, let us use the DISTINCT keyword with the above SELECT statement and see the result.
**SELECT DISTINCT Examples**
The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:
```sql
SELECT COUNT(DISTINCT Country) FROM Customers;
```
The following SQL statement lists the number of different (distinct) customer countries:
```sql
SELECT COUNT(DISTINCT Country) FROM Customers;
```
#### Problems :
1. Consider the below data from 'Order' table, write a SQL to fetch the unique regions.
2. Write a SQL to find the list of Items sold.
