Sql select distinct

Query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

MySQL DISTINCT

When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.

Here is the syntax of the DISTINCT clause:

SELECT DISTINCT
    select_list
FROM
    table_name;

Source: mysqltutorial.org

Select distinct

SELECT DISTINCT ma_colonne
FROM nom_du_tableau

Source: sql.sh

Sql select distinct

SELECT Country FROM Customers;

Sql insert for each distinct value

insert into your_table (col1, col2, col3)
select distinct col1, 'newval', col3
from your_table

Source: stackoverflow.com

Distinct in sql server

The SELECT DISTINCT statement is used to return only distinct (different) values.
Ex: select DISTINCT Country from TableName;

Similar codes

11 votes246 views1 answer
Mysql order by two columns priority
SQL
7 votes260 views2 answers
MySQL IF without else
SQL
0 vote248 views2 answers
How to prevent sql injection in java
SQL
0 vote237 views1 answer
Python connect microsoft sql server
SQL
0 vote236 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote256 views1 answer
Primary key multiple
SQL
0 vote246 views1 answer
Name '_mysql' is not defined
SQL
1 vote236 views2 answers
Postgres copy table from one schema to another
SQL
1 vote260 views1 answer
Customer using hdfc bank sql query
SQL
0 vote222 views1 answer
Stop psql server windows
SQL