Distinct sql

Query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

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

produces only one of two of the same data


returns only one of two of the same data

SELECT Country FROM Customers;

SELECT DISTINCT ColumnName FROM TableName;

SELECT DISTINCT FIRST_NAME FROM VISITORS;

Similar codes

7 votes135 views1 answer
Append column sql
SQL
11 votes161 views2 answers
Having keyword sql
SQL
0 vote130 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote145 views3 answers
How to run sql query
SQL
1 vote136 views1 answer
Postgres check blocking
SQL
0 vote142 views1 answer
Char vs varchar2 in sql
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL
0 vote181 views1 answer
Opensuse start MySQL
SQL
3 votes143 views4 answers
Truncate syntax in sql
SQL
1 vote130 views1 answer
Error code 1055
SQL