Unique values Let's assume we have the following table sales   country city amount 1 Poland Warsaw 13 2 Germany Berlin 24 3 Poland Katowice 56 And we would like to know all of the countries that the product was sold. If we use the normal query we know:  SELECT country from sales it will return  Poland Germany Poland. This is not what we are looking for because Poland is repeated twice. To solve it we can use the  DISTINCT keyword: SELECT DISTINCT country FROM sales