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;
Code Example |
---|
Sql :: sqlite unix timestamp |
Sql :: sql remove duplicate |
Sql :: postgres date |
Sql :: postgresql select case insensitive |
Sql :: sql row having max |
Sql :: oracle get foreign keys on table |
Sql :: mariadb case switch |
Sql :: BigQuery Remove Duplicate Keys From Table |
Sql :: set column width in sqlplus |
Sql :: mysql is odd |
Sql :: inner join mysql |
Sql :: display first three characters sql |
Sql :: SQL Server OPENJSON FROM table column |
Sql :: Import zipped mysql dumps |
Sql :: multiple row primary key |
Sql :: count sql |
Sql :: pgadmin postgres ERROR: database is being accessed by other users |
Sql :: create-table |
Sql :: not operator in sql |
Sql :: ORACLE CALL BACK TRACE |
Sql :: union syntax in oracle |
Sql :: procedure syntax |
Sql :: sqlcmd no headers |
Sql :: mariadb search columns |
Sql :: stuff in sql server |
Sql :: sqlcmd list tables |
Sql :: sql max value in column |
Sql :: number(10 2) in sql means |
Sql :: window function sql |
Sql :: default column value in sql same as another column laravel |