SELECT DISTINCT ma_colonne
FROM nom_du_tableau
SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/
SELECT DISTINCT Column_name FROM table_name;
SELECT DISTINCT country
FROM Customers;
The SELECT DISTINCT statement is used to return only distinct (different) values.
Ex: select DISTINCT Country from TableName;
SELECT DISTINCT "column_name"
FROM "table_name";
produces only one of two of the same data
returns only one of two of the same data
SELECT DISTINCT FIRST_NAME FROM VISITORS;
SELECT DISTINCT ColumnName FROM TableName;
SELECT ID, FirstName, LastName FROM table GROUP BY(FirstName)
SELECT Country FROM Customers;