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

9 votes331 views3 answers
Oracle undo usage by session
SQL
0 vote371 views1 answer
For select oracle
SQL
0 vote334 views1 answer
Mysql update from n to 100
SQL
3 votes346 views1 answer
Oracle list user grants
SQL
0 vote374 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
2 votes352 views1 answer
Mysql application.properties spring boot
SQL
2 votes335 views1 answer
Oracle create directory
SQL
0 vote373 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote337 views1 answer
Mssql now diff 90 day
SQL
0 vote384 views1 answer
Create table using the clause with as
SQL