DISTINCT keyword in SQL

To eliminate all duplicated data in the database, we can use DISTINCT keyword. That keyword will grab only unique data from the database. The basic syntax is:

SELECT DISTINCT Country FROM customers;

We can use more columns on this DISTINCT keyword. Just like:

SELECT DISTINCT Country, Address FROM customers;

Try it on here:

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all