SELECT DISTINCT ma_colonne<br /> FROM nom_du_tableau

SELECT DISTINCT column1, column1, ….. FROM TABLE<br /> /*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/

SELECT DISTINCT Column_name FROM table_name;

SELECT DISTINCT “column_name”<br /> FROM “table_name”;

SELECT DISTINCT country<br /> FROM Customers;

SELECT DISTINCT FIRST_NAME FROM VISITORS;

produces only one of two of the same data</p> <p>returns only one of two of the same data

SELECT DISTINCT ColumnName FROM TableName;

SELECT ID, FirstName, LastName FROM table GROUP BY(FirstName)