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

4 votes197 views4 answers
Mysql get date from datetime
SQL
0 vote166 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
3 votes182 views1 answer
Stpop start psql server
SQL
0 vote180 views1 answer
Create a table from one field of another table
SQL
0 vote189 views2 answers
Generate sql trigger through ef migration
SQL
12 votes159 views4 answers
SQL Where
SQL
0 vote168 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
2 votes141 views2 answers
Mysql get last character of string
SQL
3 votes176 views1 answer
Oracle user privileges
SQL
33 votes168 views2 answers
Postgres how to add field created at
SQL